On Fri, 2010-02-19 at 17:25 -0500, Keith Clark wrote:
> 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
>
No, that does not work.
I tried:
>date_sub(now(),interval 30 day)
And it will not allow that comparison with a timestamp column.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
