DSXchange

Sorry chullet in transformer stage under Date and Time function i saw there is only currentdate not current day so i tried by using DateOffsetByDays(CurrentDate(),((DaysInMonth(CurrentDate()) + 1)*-1)) but getting 2017-05-19. Can you please check again. Sorry i am not getting on the offset can you p...

Thanks Chullet for reply.
i tried as you suggested

DateOffsetByDays(CurrentDate(),((currentDate() + 1)*-1)) but somehow job is not getting compiled might have some issue on function.

Can you please check this again.

i tried by using but getting

2017-06-20

instead of

2017-05-31

Hello...
i have function LAST_DAY(CURRENT DATE-1 MONTH) returning results 2017-05-31 in sql giving last date of month.i needs to use the same in transformer stage .

i tried by using
DateFromDaysSince(-30, CurrentDate()) function but not works.
Please help me on this.

Thanks Ray for reply.

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

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

Yes chulett last day of previous month

Hi,

i need below transformation help in transformer

LAST_DAY(Current_Date - 1 MONTH)

please help me on this.