AppWorx, Dollar Universe and Sysload Community

 View Only
  • 1.  Offset of Processing date minus 6 month

    Posted Oct 14, 2019 10:32 AM

    Hi,

    I would like to set the processing date to last calendar date of month minus 6 month. $U offers only an offest of 88 days.
    Did someone realize something like that? (Probably scripted...)

    Regards,
    Marcus



  • 2.  RE: Offset of Processing date minus 6 month
    Best Answer

    Posted Oct 16, 2019 07:59 AM
    How to do it using scripting:
    for /F "tokens=*" %%i in ('%UXEXE%\uxdat "yyyymm" "%S_DATRAIT%" "yyyymmdd" "-7m/-1d"') do @set NEW_DATE=%%i
    echo %NEW_DATE%