Thread: Date greater then two weeks
View Single Post
  #4  
Old February 12th, 2006, 07:47 AM posted to microsoft.public.access.queries
Lp12
external usenet poster
  
Posts: n/a
Default Date greater then two weeks
Thanks a lot guys,
I used datediff......

"Ofer" wrote:

Try using the DateAdd

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


--
\\// Live Long and Prosper \\//
BS"D


"Lp12" wrote:

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