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.?
July 23, 2013 1:28 PM
October 18, 2013 3:35 PM