on 2024 Oct 22 12:48 AM
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
Request clarification before answering.
User | Count |
---|---|
5 | |
3 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.