yesterdays date

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
dsdev_123
Participant
Posts: 25
Joined: Tue Oct 09, 2007 9:13 pm

yesterdays date

Post by dsdev_123 »

Hi

I am using currentdate-1 as parameter in the file i am producing. I am using DIGITS(DateCurrentDateTime(TimeDate())) [1,8] function to get the current date but i am wondering by using the same function is there a way i can get the yesterday's date which i want to use as a parameter in the file i am producing.

Thanks
dsdev_123
Participant
Posts: 25
Joined: Tue Oct 09, 2007 9:13 pm

Post by dsdev_123 »

thanks,

i got the answer i just triekd with -1 at the end.

thanks
gateleys
Premium Member
Premium Member
Posts: 992
Joined: Mon Aug 08, 2005 5:08 pm
Location: USA

Re: yesterdays date

Post by gateleys »

Code: Select all

Oconv(Date()-1, "D-YMD[4,2,2]")
gateleys
Post Reply