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
Software/Hardware used:
Software/Hardware used:
ASKED:
June 10, 2009 7:29 PM
UPDATED:
June 10, 2009 9:04 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
