server validation

Hey Ray

Trying to use a date validation

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

But when I use the right format it still fails as you can see here:http://prntscr.com/nl8cla

What might I have done wrong to make it keep failing?

PHP is expecting a US date, so 05/16/1969, not 16/05/1969.

PHP assumes dates with slashes are in US format and dates with dashes are EU format. The easiest solution is to use the format: 16-05-1969

Another solution is to make that change in the validation code before it is validated like:

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

Ok, thanks Ray will use your solution but FYI in the server validation date selection, it clearly shows a UK style date dd/mm/yyyy (http://prntscr.com/nllx02) as an option


EDIT. Have tried your solution but it still wont pass validation...

I forgot to update the pattern in the update... Please try again. I've edited the code in my previous post.

thank you .... I've been trying to get it to work with 2 digit year format and have tried to modify it to this (based on other selections in the validation selection):

\b([12]\d|3[0-1]|0[1-9])-(1[0-2]|0[1-9])-\d{2,4}\b

but that doesnt work

I just uploaded an update to data bridge. It has a new version of the wavt_script_php.php file that should correct these issues.

have just installed the update, run the validation wizard and uploaded wavt_script_php.php but no joy.

The version of wavt_script_php.php that I have is 2.01 - not sure if thats the recent one?

It should be version 2.02. I'll send it to you.