davidvilla
Member
Is there any inbuilt validation available to validate the year field in a date?
I have a txt file, from which I will get get the dates and convert them to DATE types. If my year has any spl chars in it, DATE typecasting is not working.
Thanks in advance!
I have a txt file, from which I will get get the dates and convert them to DATE types. If my year has any spl chars in it, DATE typecasting is not working.
DEF VAR mychar AS CHAR NO-UNDO.
ASSIGN mychar = "12/12/hfjf".
DISPLAY DATE(mychar).
Result - 12/12/10.
Is there any inbuilt validations available to validate the date as such. else, I have to use ASCII codes to check them.ASSIGN mychar = "12/12/hfjf".
DISPLAY DATE(mychar).
Result - 12/12/10.
Thanks in advance!