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

Anthony Baratta Anthony at Baratta.com
Tue Jun 11 13:06:01 CDT 2002


At 03:17 AM 6/11/2002, Paul Backhouse wrote:

>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.

select col1, col2, col3 from table1
where ABS(DateDiff(dd,Now(),Pdate)) <= 14

Will that work in access??
---
Anthony Baratta
President
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."




More information about the thelist mailing list