Previous 2 months Date

sandeepJajee · Post by **sandeepJajee** » Tue Jan 26, 2010 3:48 am

Hi,

How to get the Previous 2 months from Given Date in Datastage Parallel Jobs?

Date format=yyyy-mm-dd

Any help would be appreciated.

Thanks
Sandeep

ray.wurlod · Post by **ray.wurlod** » Tue Jan 26, 2010 5:20 am

Search. This exact question has been answered within the last week.

chulett · Post by **chulett** » Tue Jan 26, 2010 6:33 am

Perhaps... depending on what exactly is meant by 'the previous 2 months'. How about an example to clear things up for us?

sandeepJajee · Post by **sandeepJajee** » Tue Jan 26, 2010 7:04 am

Hi,
I have searched the question ..its not yet answered in forum.

Ex:date=2009-04-25 [ccyy-mm-dd]

Output Date:2009-02-25

After doing conversion keep same DD and then make
sure that it is a valid date. If an end of month DD then move the
correct DD for that MM.

say for I/date=2008-04-30
after converion its 2008-02-30..but its invalid date so we have to move the correct date for that month.
if you need more information do let me know.
if we can use any routines or any functions in datastage .it would be great help for me.

Thanks.

chulett · Post by **chulett** » Tue Jan 26, 2010 8:34 am

Actually it is answered in the forum and as Ray noted, quite recently.

kpsita · Post by **kpsita** » Tue Jan 26, 2010 12:42 pm

Please check Date&Time function under Transformer/Functions.It has many functions like Days from, Months from...etc..etc