Records from now until end of next month (1 Viewer)

[2wistd]

I am using the following code to get results from next month,

Month([ptdate])=Month(Now())+1

which works great to get next months results. I try to get what is left of this month by adding the code:

Between Now() And Month([ptdate])=Month(Now())+1

This actually gives me results from July and August, eventhough it is Sept.
Basically I want the results from the remainder of this month until the end of next month.

Help!

 

[plog]

This should do it:


>=Date() AND <=DateSerial(Year(Date()),Month(Date())+2,0)

First part means its greater or equal than today, second part determines the last day of next month.

 

[apr pillai]

>=Date() AND <=DateSerial(Year(Date()),Month(Date())+2,0)

OR

Between Date() AND dateserial(year(date()),month(date())+2,1)-1