How to get yesterday date in job sequence
Moderators: chulett, rschirm, roy
How to get yesterday date in job sequence
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: How to get yesterday date in job sequence
I would use unix command
Code: Select all
date +%Y:%m:%d -d
Thanks
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You would.SURA wrote:I would use a UNIX command
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.