Datepicker - UK date format

Sorry - I know you get asked about this a lot.

I've done a search, but as far as I can tell there may be more than one variation of the datepicker code, and I haven't found how to change it.

I've found the format mm/dd/yy and changed that to dd/mm/yy, which correctly changes how it appears in the input box once selected.

But I can't see where the mm/dd/yy format is being converted to yyyy/mm/dd for SQL.

So although when it is mm/dd/yy it is getting converted correctly to yy/mm/dd, when I change to dd/mm/yy it ends up as the default 1 January 1970.

I've attached the page with the datepicker - if you could point me in the right direction to have it as dd/mm/yy in the imput box, and still end up correct in the DB that would be great.

Thank you.

line 86 of your page performs the conversion to yyyy-mm-dd format using the date() and strtotime() functions.

."" . $WA_AB_Split . "".((isset($_POST["EventDate"]) && $_POST["EventDate"]!="" )?date("Y-m-d H:i:s", strtotime($_POST["EventDate"])):"")

the problem is in the way strtotime() works. strtotime looks at the separator to determine the date format being used.

it sees the "/" separator as a US date and the "-" separator as a UK date.

to work around this problem, change the following code:

date("Y-m-d H:i:s", strtotime($_POST["EventDate"]))

to:

date("Y-m-d H:i:s", strtotime(str_replace("/","-",$_POST["EventDate"])))

Thanks Jason - I can't see anything obvious, but its giving an error on line 91:

."";

which is stopping the page from loading.

Can you spot a typo on the revised page attached?

the code at lines 83 - 91 should not be on separate lines, that code should all be one line.

Thanks Jason - I do that sometimes if I need to manually add an extra field to a page, as it just reads easier. Never had an issue with it before, and it wasn't the issue here - I'd just missed the :"") at the end of the line above.