Convert date format from form input before query

[dreampho]

Hi. I have an input field where a date is entered, format dd-mm-yy. I need to query the database to see if this date exists. How can I convert the date to yyyymmdd before the query?

 

Thanks

[creata.physics]

print str_replace( '-', '', 'yyyy-mm-dd');

 

Of course you'll need to replace 'yyyy-mm-dd' with the appropriate key for the post data, e.g. $_POST['date']

[dreampho]

Sorry, I dont understand.

 

print str_replace( '-', '', '$_POST[date]');

 

This just displays $_POST[date]

 

I am being thick ha ha

 

[darkfreaks]

$date= $_POST['date'];

$new_date = date('d-m-y',strtotime($date));

 

 

then insert $new_date into your query.

[dreampho]

Thank you, thats what I was looking for.