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

[rudy]

>  where ABS(DateDiff(dd,Now(),Pdate)) <= 14
>
> Will that work in access??


in access97,   DateDiff("d",date1,date2)

should work in later versions too


rudy