What is format in qry for TODAYminus 30 days??

[petrovlis]

I have select-query with datefield where
I need to filter:

Product field Lastupdate(Date) field

Something like Now() or today() - 30 ????

Thanks for help.
William

 

[lupins46]

Use Date()-30

If lastupdate contains a time value then you cannot get equality.

So it depends what you want to select.

 

[DUF]

Hi,
You could try Expr1artition(now()-[Date],1,120,30)
this breaks the info into groups startind with day1 ending 120 days with a grouping of 30 days - 1,120,30


hope this is of some use

Duf

 

[PHV]

If lastupdate contains a time value then you cannot get equality
For DateTime field:
WHERE ... Format(Lastupdate,"YYYYMMDD")=Format(Date()-30,YYYYMMDD) ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244