I am looking to find a way to check if a Date/Time text box on a form is in the correct format.... IE General Date.
Has Date and Time mm/dd/yyyy hh:mm am/pm.
I am using this for calculations currently they use a date picker or double click to set now(). But sometimes they will delete time and input something wrong or delete the time and just leave a date. Therefore I get a Time Field with Just a date.
I do have another text box that selects the DATE they use with a date picker(they dont ever edit this just select date then move onto TIME textbox), so I have been combining them when they delete everything or just type in a time.
Anyway I would like to put something in the BeforeUpdate event, that checks to make sure the Time textbox is in this format mm/dd/yyyy hh:mm am/pm.?
Already have something in validation rule.
thanks