Hi All,
I want to know how can we add number of months to today's date in the transformer. something like " DATE() + 12 MONTHS". As I know I can add in sql by using a sql meta tag : %dateadd( date,-no of days). But I want to do it in the transformer by writing a simple stage variable expression.
with regards,
Meena
Date transformations
Moderators: chulett, rschirm, roy
Hi Meena,
There is a function available in the Transformer - DateFromDaysSince(date,number of days),
that lets you add/subtract a certain number of days from a given date.
The second arguement in the function is of int32 type while the first is of date type.
This function is available in the Transformer, at Date & Time under Functions.
Hope this helps.
Regards,
The Bird.
There is a function available in the Transformer - DateFromDaysSince(date,number of days),
that lets you add/subtract a certain number of days from a given date.
The second arguement in the function is of int32 type while the first is of date type.
This function is available in the Transformer, at Date & Time under Functions.
Hope this helps.
Regards,
The Bird.