Month end 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
srini.dw
Premium Member
Premium Member
Posts: 186
Joined: Fri Aug 18, 2006 1:59 am
Location: Chennai

Month end date

Post by srini.dw »

Hi,

I need to calculate the end date of the month.
i.,e If i give the date like 2007-03-14, it should give me 2007-03-31.
I need to do this in transformer.

DateFromDaysSince(-1, StringToDate(DateToString(RUN_DT, "%yyyy-%mm-%dd"), "%yyyy-%mm-%dd"))
Above code works for previous month end date,

any idea how to calculate given month end date

Thanks
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”