PreviousWeekdayFromDate

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
Devendrudu
Participant
Posts: 31
Joined: Tue May 24, 2011 12:16 am

PreviousWeekdayFromDate

Post by Devendrudu »

Hi,

i am using date and time functions in transformer 8.5 as below one

PreviousWeekdayFromDate(CurrentDate(),"tuesday") that is current date is 30-08-2011.

but i am getting the output result is 2011-08-30 it's not giving Previous

Weekday.

Note: my doubt is it's giving same date what i entered in input.

Please let me know.
Devendra,Bangalore,India
MarkB
Premium Member
Premium Member
Posts: 95
Joined: Fri Oct 27, 2006 9:13 am

Re: PreviousWeekdayFromDate

Post by MarkB »

Devendrudu wrote:Note: my doubt is it's giving same date what i entered in input.
That's probably because the 30th IS a Tuesday, and I believe PreviousWeekdayFromDate includes the source date. If you had specified MON (or Monday), it would have returned the 29th.
Post Reply