General information
Category:
Coding, syntax & commands
Gary,
Try:
EMPTY( CTOD(YourCharacterDateString) )
if EMPTY is .T. it's an illegal date string
>Hello All!
>
>Is there any way to test whether a date constant/string is a valid date ?
>
>For example, if a constant is assembled as follows :-
>
>{^2001/06/31}
>
>Clearly, this is an invalid date as there are only 30 days in June. To test whether a date string is valid, I could set up an error handler and subject this date string/constant to a date calculation. If it fails, then it is trapped and I have an invalid date.
>
>However, is there a way to do this without an error handler, just using this value in some form of expression that returns True/False or a DateValue/EmptyDateValue or similar ?
>
>Any tips much appreciated.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only