I have a file field(InpDate) which is of length 6A. It is assumed to have value in ddmmyy format. I am extracting the day month and year part of it using
Day = %Dec(%Subst(InpDate:1:2):2:0)
Month = %Dec(%Subst(InpDate:3:2):2:0)
Year = %Dec(%Subst(InpDate:4:2):2:0)
Since am doing a %Dec, I want to test whether the InpDate field has valid value. But I am not able to use Test(DE) opcode on a DMY format(ie ddmmyy). Can anyone help me to reach my goal.?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!