previous sunday date from current 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
kalpna
Premium Member
Premium Member
Posts: 78
Joined: Thu Feb 02, 2006 3:56 am

previous sunday date from current date

Post by kalpna »

Hi Evryone
Can any one give me an idea to get the previous mentioned day's(eg,.Sunday) date from current date.
I found a function 'PreviousWeekdayFromDate', but, i didn't understand the functionality.
Example: todays date is 19-09-2006 i need the last sundays date which is, 17-09-2006

Thanks in advance
kalpna
keshav0307
Premium Member
Premium Member
Posts: 783
Joined: Mon Jan 16, 2006 10:17 pm
Location: Sydney, Australia

Post by keshav0307 »

PreviousWeekdayFromDate(CurrentDate(),'Sunday') will give you the result
Post Reply