D dgmorr Registered User. Local time Today, 01:07 Joined Jan 10, 2007 Messages 71 Jun 11, 2007 #1 Hey guys, I'm trying to pull data that has a due date within 30 days from the current date. I'm trying to use WHERE x <= Now() + 30 but I'm getting incorrect records. Can someone please help me out? Thanks.
Hey guys, I'm trying to pull data that has a due date within 30 days from the current date. I'm trying to use WHERE x <= Now() + 30 but I'm getting incorrect records. Can someone please help me out? Thanks.
rainman89 I cant find the any key.. Local time Today, 01:07 Joined Feb 12, 2007 Messages 3,013 Jun 11, 2007 #2 its the dateadd function u are looking for dateadd("d",30,date()) so its BETWEEN Date() And dateadd("d",30,Date())
its the dateadd function u are looking for dateadd("d",30,date()) so its BETWEEN Date() And dateadd("d",30,Date())
D dgmorr Registered User. Local time Today, 01:07 Joined Jan 10, 2007 Messages 71 Jun 11, 2007 #3 Thank You!
rainman89 I cant find the any key.. Local time Today, 01:07 Joined Feb 12, 2007 Messages 3,013 Jun 11, 2007 #4 in your date feild criteria you would put the code i showed u. BETWEEN Date() And dateadd("d",30,Date()) you could use now() but date() is just the date. now has a time associated with it
in your date feild criteria you would put the code i showed u. BETWEEN Date() And dateadd("d",30,Date()) you could use now() but date() is just the date. now has a time associated with it
