HI
In the Transfomer Input fileld is date
I want to subtract days (like 25) then populate to output field in the form of yyyy-mm-day.
Is it possible ? Then what is syntax
Srini
subtracting days from date in transformer
Moderators: chulett, rschirm, roy
-
srinivas Guduru
- Premium Member
- Posts: 38
- Joined: Sat Dec 29, 2007 9:58 am
DateFromDaysSince() to add or subtract days from a date.
DateToString() if you are populating a Char/VarChar output column. If a Date datatype, there is no need to format it. It's all in how you view it.
Plenty of examples of both here on DSXchange and in the product documentation.
---EDIT: Just corrected the function name to DateFromDaysSince---
Regards,
DateToString() if you are populating a Char/VarChar output column. If a Date datatype, there is no need to format it. It's all in how you view it.
Plenty of examples of both here on DSXchange and in the product documentation.
---EDIT: Just corrected the function name to DateFromDaysSince---
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.