I want only tomorrow's date

[trythis]

In my database today's date looks like this

Between Date() And Date()+1

This shows me today with all of the scheduled times.

How do I make it give me only tomorrow and only the next day

I tried Between Date() And Date()+2 it gave me today and tomorrow. I want to seperate today and tomorrow.

If today is Friday 8/28/2009 I want only tomorrow Saturday 8/29/2009

I have this that shows me current week

DatePart("ww", [SalesDate]) = DatePart("ww", Date()) and Year( [SalesDate]) = Year(Date())

Like say I only want Thursday of the current week and today is Monday.

help
Tina

 

[boblarson]

Wouldn't it just be

For only tomorrow:
Between Date()+1 And Date()+2

and variants of it

for only tomorrow and the next day:
Between Date()+1 And Date()+3

etc.

 

[trythis]

Thank You again you are great.

Tina

 

[trythis]

I actually figured something out on my own. I was beginning to wonder???

I will put it here incase anyone else needs it.

this gives me 2 days from today. Since today is 8/28/2009 this gives only the data for 8/30/2009.

Between Date()+2 And Date()+3


Thanks,
Tina