Date Expression

[jcuiskelly]

Does anyone know how to write an expression to capture data for the prior month when the current month has less number of days then the prior month?  The expression I used only captures data from 01/01/07 to 01/28/07 because there are only 28 days in the February.  Here is the expression: between _add_months(_first_of_month(CURRENT_DATE), -1) and _add_months(_last_of_month(CURRENT_DATE), -1).   Thanks

[COGNOiSe administrator]

Substract one day from the first day of current month ...