Date greater then two weeks

[Lp12]

Hi All,
i have a query with OpenDate as date.
I want to show the records where the OpenDate is greater than two weeks time
(in the criteria)
How can i accomplish that?
Thanks in advance

 

[Michel Walsh]

Hi,


OpenDate is greater that two weeks time... than what? than today? and two
weeks is 14 days or there has been two end of weeks between the two dates?


14>= DateDiff( "d", OpenDate, Now)

for 14 days, or, for two week changes

2 >= DateDif"f("ww", OpenDate, Now)


Hoping it may help,
Vanderghast, Access MVP

 

[Ofer]

Try using the DateAdd

Where FieldName > DateAdd("ww",2,Date())

 

[Lp12]

Thanks a lot guys,
I used datediff......

Try using the DateAdd

Where FieldName > DateAdd("ww",2,Date())