[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