Show results older than 2 weeks

[MaxMark]

Hi, just a quick (and probably stupid) question.

I need to show results of certain items that are OLDER than 2 weeks, how exactly would i do that?

Thx for any help you can give

 

[daveUK]

Use the dateAdd function in a query. The following code will show all the records older than 2 weeks.

<DateAdd("m",-2,Date())

HTH