date query

[iain]

hi,

in a database i have, it would be useful to have a report
that brings up records of developments which have been
completed recently.

is it possible to have a report which will bring up
records with a *completed date* field say that equalled
date () - minus 30 days, and if so, what would the syntax
be? if that makes sense.

i know yuo could just enter the dates each time, but this
would cut out that step.

cheers,
Iain

 

[Casey]

Iaian,

You could use the >=Date()-30 in your query criteria
of the date field you use log completion. If you want to
bring the ones that have been completed lets say within
the ten days of that 30 day mark, you could use.