Hello
We are pulling information from SAP Sharp and the records person YYYYMM tract values. E.g. 202401, 202409, 202410 etc. We would similar to filter the records based connected "Last period and existent month'.
We person declared beneath planetary variables:
$GV_LMONTH as (month(sysdate()) - 1) + 12*(1 - floor((month(sysdate()) + 10) / 12))
$GV_LYEAR as year(sysdate()) - 1 + floor((month(sysdate()) + 10) / 12)
$GV_SDATE as |$GV_LYEAR||$GV_LMONTH|
Now successful the Filter tab of CI-DS task, we person enactment beneath code
"GSC_YEARMONTH" >= $GV_SDATE
But CI-DS is giving syntax error. Any thought however we tin extract records based connected past period + existent period for the values from YYYYMM tract from information records ?
Thanks