[SOLVED] Comparing dates

[soycharliente]

In my db table, my date field uses YYYY-MM-DD, but if you compared 2007-6-1 to 2007-06-01 you would get FALSE. What can I do about this? I'm passing days using the GET method and then populating an events div with events from a db table that match the D M and Y.

 

I would like it to work for both numbers with and without leading zeros.

 

[AndyB]

Whether they're passed with GET or POST makes no difference. You'll need to process them in some way to get a yyyy-mm-dd string for comparison purposes unless you use a user input method that only allows correctly formed dates, i.e. a dropdown. Meantime, the below should suffice to convert inputs retrieved from a passed array.

 

$iso_date = date("Y-m-d", strtotime(0,0,0,$m,$d,$y));

[soycharliente]

I have a calendar with each day being a link that just passes what D M Y it corresponds to into the URL.

 

SO when I process the page, I should take the D M Y from the GET array and use the date() function and mktime() to get the format that I need?

[AndyB]

Yup. mktime not strtotime (got up too early today, obviously)

[soycharliente]

ROFL. I didn't even notice you said strtotime(). I read mktime().