Date serial for 2 months prior

[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.

 

[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.

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

 

[KARL DEWEY]

Try this --
DateSerial(Year(Date()),Month(Date())-1,0)