date will not validate

Using CS6 and Data Bridge 1.2.3
I'm having trouble validating a date field. WA Server Validations are set as allow mm-dd-yyyy format. The validation passes as long as the "day" portion of the date is 01-12, otherwise the validation fails. For example, 09-12-1996 validates but 09-13-1996 fails. 07-07-1996 validates but 07-15-1996 fails. This issue appears on both the insert and update pages. What am I missing?

Dates separated with dashes instead of slashes are considered European date format by php. That means 09-01-1996 would be interpreted as January 9th. This explains why it is failing, but really our server code should account for it and allow it to pass.

I think the easiest solution is to use slash formatted dates like: 09/13/1996 instead of 09-13-1996 because that will solve the problem without needing to do any more. I can look into the issue with dashed dates in the meantime and try to get a fix out so that it will work properly in the future.

Thank you for your reply. If my only option is to switch to slashes / then I guess I will have to. This will cause inconsistencies since I have over 5000 entries in MySQL already using dashes and it will break code used to calculate a persons age. I initially chose dashes because that is how MySQL formats DATESTAMP.

Another solution would be to only replace it in the validation...

so on the insert page line 25 you can change it to:

$WAFV_Errors .= WAValidateDT(((isset($_POST["dob"]))?str_replace("-","/",$_POST["dob"]):"") . "",true,"\b(1[0-2]|0[1-9])/([12]\d|3[0-1]|0[1-9])/\d{4}\b","","",false,".*","","",true,13);