Date Verification

[JRG0620]

I apologize if this has been posted in a prior thread but I cannot seem to find what I’m looking for so I’ll ask via a new thread.

I need a date validation routine that will determine if the date entered is in the proper format. I have several unbound fields on my form and the dates are in many different formats. I.e. mmyyyy, mmddyy, yymmdd. Why, I have no idea. I inherited this application. The user is now saying they want to ensure that the dates entered are in the correct format. I have put a short date input mask on the fields that I can but it still allows me to enter any number. Is there a function that can be called to verify that the month and day entered are a correct combination or do I have to write my own routines.
Thanks for any help.

 

[gemma-the-husky]

if you have control of the application, then you should limit date input into a datetime datatype - then they are necessarily genuine dates

if you THEN need to change them into some text representation you can just use

format(actualdate,"yymmdd"), or watever text representation you want.