[RESOLVED] another date formating issue...

vinny199

Hi,

I am using a javascript imput date calendar to search events by date.

When you select a date, an input text field gets filled up imediatly with the value selected in the calendar.

So, if I pick a date of the calendar, the textflied lists the selected date as: DD/MM/YYYY

which is perfect as it is a UK website.

The problem is that all dates in my database have been inputed as YYYY/MM/DD

So when I click on the "Search button" I would need to have my date: DD/MM/YYY Y converted" to YYYY/MM/DD so the database can be searched properly and return the matching value

Do you know what I mean?

Is there a way to create a function to do that?

How should I go about this?

Vinny

bodzan

$d = explode("/",$date);//$date is formated as DD/MM/YYYY
$nd = $d[2]."/".$d[1]."/".$d[0];//now $nd is formated like YYYY/MM/DD

Peteinnews

Personally, when storing dates, I try to use strtotime whenever possible. Storing the timestamp, in my opinion, makes it much easier to sort by date and helps tremendously with display formatting.

Paul Wib provides an strtotime_uk function on the php.net help page.

function strtotime_uk($str)
{
   $str = preg_replace("/^\s*([0-9]{1,2})[\/\. -]+([0-9]{1,2})[\/\. -]*([0-9]{0,4})/", "\\2/\\1/\\3", $str);
   $str = trim($str,'/');
   echo "Converted to UK date: $str<br>";
   return strtotime($str);
}

vinny199

many thanks
i used the first method, but I'm trying the strtotime one now.