On Fri, 2010-02-19 at 17:05 -0500, Drew Jensen wrote:
> 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
>
>
Drew,
Sorry about some confusion here. I'm connected to a MySQL database.
Keith
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
