how to test string for proper formatting (1 Viewer)

[dreamdelerium]

hey everyone. i was wondering if anyone knows how to test a string to see if its formatted corretly. on a form, before sending it to the table, i have a field for Date of birth. because some of the people who will be filling in this form dont know their birthdays i need to be able to take in three varietys of strings. they are:

dd/mm/yyyy or yyyy or unknown. i need to differentiate between the first two because i need to figure out the ages.

thanks

 

[chergh]

You can differentiate between the dd/mm/yyyy and yyyy simply by using the 'len' function

 

[dreamdelerium]

duh

yeah, that should work. why didnt i think of that lol