OTBI filter help

Question

I want add the condition for the filter to pull last month whole data based on running month. Column name is "Assignment Absences Details"."Date Start"

Please help

Reddykrishna · Answer

Thank you @Sovitendu Jalli-Oracle  it helps a lot

Sovitendu Jalli-Oracle · Answer

Hi Krishna Reddy,

Please use below expression in the filter expression.

CAST("Assignment Absences Details"."Date Start" AS DATE) BETWEEN TIMESTAMPADD(SQL_TSI_MONTH, -1, TIMESTAMPADD( SQL_TSI_DAY ,DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE))

AND TIMESTAMPADD( SQL_TSI_DAY , -(1),TIMESTAMPADD( SQL_TSI_DAY ,DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE))