Search found 4 matches
- Wed May 06, 2009 1:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to get the last business day of the given month.
- Replies: 8
- Views: 3404
Hey i found very easy way to get Last business date
Replace lnkname.colname with your linkName.ColName accordingly :D If (WeekdayFromDate( (DateFromDaysSince(-1,StringToDate( (If MonthFromDate((StringToDate(lnkname.colname,"%yyyy-%mm-%dd")))='12' Then YearFromDate((StringToDate(lnkname.colname,"%yyyy-%mm-%dd")))+1 Else YearFromDa...
- Tue May 05, 2009 12:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to get the last business day of the given month.
- Replies: 8
- Views: 3404
- Mon May 04, 2009 8:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to get the last business day of the given month.
- Replies: 8
- Views: 3404
How to get the last business day of the given month.
Hello Experts, I have an issue which sholud bring the last working date or Business date in a month.So how can i do this with the help of datastage Functions.Since my job having Source as Txt file and Target is DB2. Ex:- Date from Source:- 2009-05-02 Target sholud be:- 2009-05-29 (friday) plz help m...
- Sat May 02, 2009 5:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to Get last working day of every month.
- Replies: 1
- Views: 758
How to Get last working day of every month.
Hello Experts, I have an issue which should bring the last working date or Business date in a month. So how can I do this with DataStage Functions? My job has a Source as Txt file and Target is DB2. Ex:- Date from Source:- 2009-05-02 Target should be:- 2009-05-29 (friday) plz help me yaar...... :( *...