cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Global variables in CI-DS not working

Prashant_Pradhan
Newcomer
0 Kudos
199

Hello

We are pulling data from SAP Sharp and the records have YYYYMM field values. E.g. 202401, 202409, 202410 etc. We would like to filter the records based on "Last month and current month'. 

We have declared below global 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 in the Filter tab of CI-DS task, we have put below code

"GSC_YEARMONTH" >= $GV_SDATE

But CI-DS is giving syntax error. Any idea how we can extract records based on last month + current month for the values from YYYYMM field from data records ? 

Thanks

 

Accepted Solutions (0)

Answers (0)