Date function ..Date..DateSerial

[hello101]

Hello everyone!

I need help figuring out this:

I want to return the total volume generated based on these periods: the beginning of this month until today's date (say for example today's date is the 15) then the beginning of the past month until the same date as today of the last month (which is december 15 for example). I have no problems writing the first part which is >= DateSerial(Year(date), Month(date), 1)<= Date() but I can't figure out how to do that for the previous month. DateSerial(Year(date), Month(date) - 1, 1) is the first day of last month, but what about the same day as today of the previous month?

Thank you

 

[Remou]

How about:

[tt]DateSerial(Year(Now()),Month(Now())-1,Day(Now()))[/tt]