Date serial for 2 months prior

L

LisaK

Hello,

I am using the date serial function in a query to pull data that is reported
2 months after the fact. I can get the start date to work
DateSerial(Year(Date()),Month(Date())-2,1). But I cannot get the end date to
come up correctly. Can someone please help me on this one.

Thanks much.
 
J

John W. Vinson

Hello,

I am using the date serial function in a query to pull data that is reported
2 months after the fact. I can get the start date to work
DateSerial(Year(Date()),Month(Date())-2,1). But I cannot get the end date to
come up correctly. Can someone please help me on this one.

Thanks much.
Click to expand...

Not without knowing what you consider the end date. You didn't say!

GUESSING that you want all the records from January 2010 if you run the query
today, try
 
Top