date convertion with month increment by 1

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
A_SUSHMA
Participant
Posts: 43
Joined: Fri Apr 12, 2013 10:34 am

date convertion with month increment by 1

Post by A_SUSHMA »

Hi,

I have one requirement .

My Source is

7/29/36
9/12/82
5/18/64


I want output is

1936-08-29
1983-01-09
1964-06-18

In the above example month should be increment by 1.
dsetlteam
Premium Member
Premium Member
Posts: 35
Joined: Mon Feb 10, 2014 10:14 pm
Location: USA

Post by dsetlteam »

DateOffsetByComponents(%basedate%,%yearoffset%,%monthoffset%,%dayoffset%) can do the trick for you
A_SUSHMA
Participant
Posts: 43
Joined: Fri Apr 12, 2013 10:34 am

Post by A_SUSHMA »

Thanks for your reply.
I got output.
Post Reply