date manipulation using start and enddates

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
satheesh_color
Participant
Posts: 182
Joined: Thu Jun 16, 2005 2:05 am

date manipulation using start and enddates

Post by satheesh_color »

Hi All,

I have startdate and enddate as an incoming columns, based on which i would like to get everymonths between the given dates.

StartDate:10/18/2014
EndDate:03/22/2015

Expected output:
1-10-2014
1-11-2014
1-12-2014
1-01-2015
1-02-2015
1-03-2015

Kindly let me know your thoughts on the same.


Thanks,
Satheesh.R
Top
Post Reply

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