Re: Date sorting Criterion

On 2/19/2010 4:51 PM, Keith Clark wrote:
> How would I select my data, in design view, using a criterion like:
>
> now()-30 days
>
> That does not seem to work btw.
>
Hell Keith

Right now, using the embedded database engine, you can't do that - well, 
you already know don't you.
In the next major release 3.3 this will be available by the way.

In the meantime you can do this:

DATEDIFF('dd', "date_col", CURDATE() ) = 30


There is a rather old post on playing with dates in a "tickler" use case 
which you can find here:
http://www.oooforum.org/forum/viewtopic.phtml?t=24480&highlight=tickler

I see that a few of the items aren't showing on that post but the part 
you may be interested in is still there.

HTH

Drew