Query +45days +1month

[Matt Brown]

I have been trying to solve a date criteria problem but to no avail.

I have been asked to set the criteria of a query so that the data result set is +45 days from Now() and from that point one months worth of data.
Basically trying to create a forward date window which is 45 days ahead and shows 1 month worth of data from the 45th day.

Any ideas would be appreciated.


Thanks
Matt

 

[Dugantrain]

between Date()+45 and Date()+75 maybe? This will get you 30 days worth of data beginning 45 days from today.

 

[Jon K]

BETWEEN Date()+45 AND DateAdd("m",1,Date()+45)

 

[Matt Brown]

Thanks guys, for your inputs, both answers seem to work fine.

Matt