[thelist] Show Records from table where properties have been added in the last 2 weeks

Paul Backhouse paul.backhouse at 2cs.com
Tue Jun 11 05:18:01 CDT 2002


Has anyone got any ideas?
My minds gone blank.

I have a search tool, where they can click records added in last 2 weeks.

The record in the table is: Pdate

Was thinking about using the DateDiff function to work out if the date is
within 14 days.
But im not havign much luck.

The database is Access.
So any ideas?

Cheers

Skuff




More information about the thelist mailing list