If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Date greater then two weeks
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 |
#2
|
|||
|
|||
Date greater then two weeks
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 "Lp12" wrote in message ... 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 |
#3
|
|||
|
|||
Date greater then two weeks
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 |
#4
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Adding info to query | mjj4golf | Running & Setting Up Queries | 20 | January 9th, 2006 02:29 AM |
Trying to return the 1st date value greater than a starting date v | Pants00 | Running & Setting Up Queries | 2 | December 29th, 2005 08:46 PM |
Addition to Turn cell red if today is greater or equal to date in cell | Rich | New Users | 2 | December 9th, 2004 02:06 AM |
calculate weeks from a start date ( not yr weeks) | Todd F. | Worksheet Functions | 6 | November 27th, 2004 05:53 PM |
Does date fall between two ranges? | MR | Worksheet Functions | 4 | January 14th, 2004 04:08 PM |