On Fri, 2010-02-19 at 17:12 -0500, Keith Clark wrote:
> 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
This actually seems to work in the design view Criterion box:
< NOW( ) - 00000100000000
Returns all dates older than 30 days from now.
Keith
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
