DSXchange

Posted: **Wed Jan 23, 2013 12:21 am**

I want the Previous day of sysdate logic in User variable activity stage in job sequence.Please help me.

Posted: **Wed Jan 23, 2013 1:47 am**

@DATE - 1

or

Date() - 1

This gives yesterday's date in DataStage internal format. To convert to human-readable format use Oconv() function. For example

Oconv(@DATE - 1, "D-YMD[4,2,2]")

Posted: **Wed Jan 23, 2013 5:30 am**

Please explain with one example.

Posted: **Wed Jan 23, 2013 7:56 am**

He did. Which part is unclear? There are plenty of examples of OConv() syntax here or in the documentation if that is an issue.

Previous day in User variable activity