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
Substract one day from the first day of current month ...