Date serial for 2 months prior

  • Thread starter Thread starter LisaK
  • Start date Start date
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.
 
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
 
Back
Top