Subtratc few days from a 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
swerajan
Participant
Posts: 42
Joined: Tue Aug 05, 2008 4:34 am

Subtratc few days from a date

Post by swerajan »

Hi all

I need to subtract few days from a given date. How can i do this? Pls guide me through the steps.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Nothing easier than that - use the "DateFromDaysSince" function as described on page 594 of the Parallel Job Developer Guide
srinivas.g
Participant
Posts: 251
Joined: Mon Jun 09, 2008 5:52 am

Post by srinivas.g »

first convert the given date to julian day and subtract the days and convert to date format
Srinu Gadipudi
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Or just use the DateFromDaysSince function with a -2 for the number of days.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply