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.
Date function in transformer stage
Moderators: chulett, rschirm, roy
You might want to check out the DateOffsetByDays function. If you take the system date and "offset" it by the ((current day + 1) * -1) days, you'll get the last day of the previous month.
Last edited by chulett on Mon Jun 19, 2017 2:09 pm, edited 1 time in total.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
i tried by using
but getting
Code: Select all
DateOffsetByDays(CurrentDate(),1)
instead of2017-06-20
2017-05-31
SUKH
Sorry chullet in transformer stage under Date and Time function i saw there is only currentdate not current day so i tried by using
but getting 2017-05-19.
Can you please check again.
Sorry i am not getting on the offset can you please help what should i give the whole function in transformer stage.
Code: Select all
DateOffsetByDays(CurrentDate(),((DaysInMonth(CurrentDate()) + 1)*-1))
Can you please check again.
Sorry i am not getting on the offset can you please help what should i give the whole function in transformer stage.
SUKH