How to get yesterday date in job sequence

[vamsi_4a6]

In job sequences How to get yesterday date in job sequence.For todays date we can use DSJobStartDate and in parallel jobs we can use dateoffsetbycomponents not sure about job sequences.

[qt_ky]

Have you tried searching?

[chulett]

Seriously, it's not like you're the first person to ask this over the years. Short answer? Today's date in internal format, subtract 1, convert to external.

[ray.wurlod]

Note, in particular, that sequence jobs are NOT parallel jobs. They execute using the server engine. You do NOT need parallel job functions in sequence jobs.

[SURA]

I would use unix command

Code: Select all

date +%Y:%m:%d -d

[ray.wurlod]

I would use a UNIX command

You would.

But there are perfectly adequate DataStage BASIC expressions that can be used directly when assigning parameter values in a job activity (or storing them in user variables) without the need to create additional shells.

For example @DATE - 1 returns yesterday's date (based on the sequence start time) in internal format, while Date() - 1 returns yesterday's date (based on the system time when it is executed) in internal format.