Its 1st Case Sunday to Saturdayray.wurlod wrote:What is your business rule for "last day of week"? In some countries weeks run from Sunday to Saturday, in other countries Monday to Sunday, etc. Without that knowledge no generic answer can be give ...
Search found 2 matches
- Wed Jan 20, 2010 8:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DS-PX Day from Date
- Replies: 4
- Views: 1366
- Wed Jan 20, 2010 3:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DS-PX Day from Date
- Replies: 4
- Views: 1366
DS-PX Day from Date
Hi Folks
How to get lastday of the last week with referance to todays date(ie 20/0/2010).
Ex: suppose todays date is 05/01/2010 and I need last day of the last week(Ans should be 02/01/2010 ).
How to get lastday of the last week with referance to todays date(ie 20/0/2010).
Ex: suppose todays date is 05/01/2010 and I need last day of the last week(Ans should be 02/01/2010 ).