Access Queries

[BelindaN]

Hi

I've created an Access Query but in one of the date fields I need to filter the data so that it only shows me prior to the last 30 days. The last 30 days prior to todays date (which updates every day) must not be seen.

Maybe it would be something like "now()-30"?

Please help me.



Belinda

 

[Tanis]

Hi Belinda. Try this.

SELECT tblTableName.FieldName, DateDiff("d",Date(),[FieldName]) AS DayDifference
FROM tblTableName
WHERE (((DateDiff("d",Date(),[FieldName]))<(-30)));

David

 

[Dugantrain]

Or you could just use

Date()-30

as a cheap hack.