This content has been marked as final. Show 4 replies
in criteria tab for the date column click on filter icon then select between operator use SQL Expression as current_date
this should show data from last 45 days.
If helps mark as correct
Please elaborate your answer means how to write sql Expression.
In criteria tab->Date Column->Filter Icon->Choose Between->Add button->Select SQL Expression and then use current_date-45
and Select SQL Expression use current_date
if helps mark
if you prefer you can use the TIMESTAMPADD function - TIMESTAMPADD(SQL_TSI_DAY, -45, CURRENT_DATE)
This function will return you the 45 days back data based on the current date.