Date element validation rule

[jo-ka]

Hello,

Can you please help me find the best way to set a validation rule where the date shouldn't be greater that "today"?

Thank's in advance.

 

[jo-ka]

Friendly bump...

 

[troester]

php validation
return $data <= date('Y-m-d 00:00:00');

 

[dimoss]

Hi

This is what I use in a date element to check the date against a predefined one in another table.

date_default_timezone_set('UTC');
$db = & JFactory::getDBO();
$tour = (int)'{table___tournament_raw}';
$current = strtotime(gmdate('Y-m-d H:i:s'));
$query = "SELECT deadline FROM table WHERE id = $tour";
$db->setQuery( $query );
$dt = $db->loadResult();
$deadline = strtotime($dt);
return $deadline > $current;

I think it can help u to start or modify it to get what u want.

 

[dimoss]

php validation
return $data <= date('Y-m-d 00:00:00');

But this one is direct to the point.

 

[jo-ka]

Well, thanks guys.
I need to have the today's system date and not a fixed date.

So, shall something like this would work? I've tried but all I've got is a blank page...

return $data <= CURDATE();

 

[troester]

date('Y-m-d 00:00:00') is the current date.
CURDATE() is SQL not php

 

[jo-ka]

Oh God! What a dummy.

OK, thank's. It's working now.

 

[troester]

I'm not sure about timezones, nor of $data nor of date()...
If it's relevant do some var_dump

 

[jo-ka]

I'm not sure about timezones, nor of $data nor of date()...
If it's relevant do some var_dump

OK, in that case, couldn't we use also dimoss suggestion?

date_default_timezone_set('UTC'); (or the needed time zone)

before

return $data <= date('Y-m-d 00:00:00')

Thanks in advance.

 

[cheesegrits]

Well, first make sure it's an issue before trying to solve it. Dump your $data ...

var_dump($data, date('Y-m-d 00:00:00');exit;

... and see if it looks like you need to figure TZ's out.

-- hugh