Get Started with Redwood for Oracle Cloud HCM Begin Now
OBI - SQL filter to show only current month ?
Summary:
Content (required):
Hello,
I have a Req. Historical Status Start Date set to the following SQL filter, the idea is to show results for the current month :
"Requisition Status - Historical"."Req. Historical Status Start Date" >= (TimestampAdd (SQL_TSI_DAY, -(DAYOFMONTH (CURRENT_DATE)-1) , CURRENT_DATE))
Yesterday on July 31st, the filter was returning results fine, but today on August 1st, I have a No Results.
Could you give me the correct filter to use ? Thanks in advance for your help !
Best regards,
Marcel.
EDIT : nevermind of course there are no results today, since there's no requisitions that were done today. The formula is correct.
Tagged:
0