Transformation help required in Transformer

harman · Post by **harman** » Tue Apr 12, 2016 1:21 pm

Hi,

i need below transformation help in transformer

LAST_DAY(Current_Date - 1 MONTH)

please help me on this.

chulett · Post by **chulett** » Tue Apr 12, 2016 1:53 pm

So... in other words... you need to find the last day of the previous month?

harman · Post by **harman** » Tue Apr 12, 2016 2:08 pm

Yes chulett last day of previous month

qt_ky · Post by **qt_ky** » Tue Apr 12, 2016 2:08 pm

Please clarify what is meant by minus 1 month... is it meant as "previous month" or subtract 30 days, etc.?

harman · Post by **harman** » Tue Apr 12, 2016 2:11 pm

minus 1 month means previous month

values
LAST_DAY(Current_Date - 1 MONTH) i ran this statement in db2 and got the result
2016-03-31 same i need through datatstage

Mike · Post by **Mike** » Tue Apr 12, 2016 6:38 pm

That's pretty straight forward these days with a couple of parallel transform functions: one to subtract a month and another to get the number of days in a month.

What I don't remember though... in what version was the DaysInMonth function added? It's relatively new and I don't remember if it existed in version 9.

Mike

ray.wurlod · Post by **ray.wurlod** » Tue Apr 12, 2016 6:59 pm

Last day of previous month is a one day (-1 day) offset from the first day of the current month.

Therefore the easiest solution is to build the first day of the current month by subtracting the current day number in the month from the current date.

Functions are DateFromDaysSince() and MonthDayFromDate(). The rest is simple arithmetic.

harman · Post by **harman** » Wed Apr 13, 2016 9:41 am

Thanks Ray for reply.

can you please help me by providing the transformation i can use in transformer

ray.wurlod · Post by **ray.wurlod** » Wed Apr 13, 2016 5:09 pm

I provided you with the needed functions - please experiment with these as a learning experience.

I prefer to teach you to fish rather than to give you a fish.
If I give you a fish that's consulting, and you pay for my time.