Issues with date filtering

[Jimbos]

Hello,

I've a problem with date filtering:

this query works: 

$today = date("Y-m-d", strtotime('today'));
$pages->find("template=page, sort=datetime, datetime>=$today");

but this not:

$today = date("Y-m-d", strtotime('tomorrow'));
$pages->find("template=page, sort=datetime, datetime<=$tomorrow");

why?

Thank you!!

[zoeck]

inside a selector you have to use a timestamp ? 

Just use strtotime without date(), i think it should work ? 

<?php
$today = strtotime('tomorrow');
$pages->find("template=page, sort=datetime, datetime<=$tomorrow");

 

[Jimbos]

Thank you zoeck,

never works, it seems a problem related to the datetime field.

Filter the pages through this field doesn't works.