Q:
Date Conversion In Crystal Reports 11
I have a datafield {artrans.invdte} thats is a string lenght of 8 formated "MM/DD/YY" trying to check this date against ToText(currentdate, "MM/DD/YY") to select records not working .
Tried a pramater field @date
StringVar DT := {artrans.invdte};
NumberVar YR := Val (Split (DT , '/')[3]);
if YR < 50 then YR := YR + 2000 else
if YR < 1000 then YR := YR + 1900;
Date ( YR,
Val (Split (DT , '/') [1]),
Val (Split (DT , '/') [2]) )
didn't work
Tried a pramater field @date
StringVar DT := {artrans.invdte};
NumberVar YR := Val (Split (DT , '/')[3]);
if YR < 50 then YR := YR + 2000 else
if YR < 1000 then YR := YR + 1900;
Date ( YR,
Val (Split (DT , '/') [1]),
Val (Split (DT , '/') [2]) )
didn't work
ASKED:
Jun 10 2009 7:29 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
