Query by Date plus 7 days in advance

[Beretta22]

I need someone's help in what expression do I use to query on todays date plus 7 days in advance. All I can find is Date Range parameters. (Not what I need) Any ideas?

 

[danvlas]

Date()+7

or

DateAdd("d", 7, Date())

Good luck

Daniel Vlas
Systems Consultant
danvlas@yahoo.com

 

[Beretta22]

Thanks for the info. However, the DateAdd("d", 7, Date())
only gave ne the 7th day from todays date. I need to include dates between today and the 7th day. Any ideas?

 

[danvlas]

"I need to include dates between today and the 7th day"
That's the answer. In the criteria row, type:

Between Date() And DateAdd("d", 7, Date())

or

Between Date() And Date() + 7


Daniel Vlas
Systems Consultant
danvlas@yahoo.com

 

[Beretta22]

Well that did it!!! Cannot thank you enough. No wonder I read all the posts here, you guys are GREAT... Thanks again

 

[knowone]

What about dates in the past ie: the last 30 days?

- - - KnowOne Says Thank You - - -
​

 

[danvlas]

Date()-30

or

DateAdd("d",-30)

I remember attending a lesson where they taught about negative numbers...but it was a long time ago...

The past is the 'negative future'

Daniel Vlas
Systems Consultant
danvlas@yahoo.com