In the following two ways, I calculate, for example, some dates that I have as parameters in a control job m.
#Sysdate calculation - 1 (YYYYMMDD format for yesterday)
%%$CALCDATE %%$ODATE -1
#I calculate sysdate date (YYYY-MM-DD format for today) (The point is to concatenate)
%%$OYEAR.-%%OMONTH.-%%ODAY
My question is: how can I calculate yesterday’s date in YYYY-MM-DD format?
That is, if today is June 18, 2024, how do I generate 2024-06-17?