Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is Date String A Valid Date?
Message
From
04/07/2001 19:28:37
Jill Derickson
Software Specialties
Saipan, CNMI
 
 
To
04/07/2001 19:16:38
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00526801
Message ID:
00526802
Views:
24
This message has been marked as the solution to the initial question of the thread.
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
Map
View

Click here to load this message in the networking platform