DSXchange

All,
I need to do a calculation in transformer. Kind of confused.

We have data in below format:

ID,DATE,STATUS
A,20150228,Active
B,20150228,Active

Now, if the process runs on March 31st, and if current date is more than DATE+31days then change status to Expired. So, if process runs on 2015-03-15 and as DATE is not 20150228+31 days, then it should be active.

Thanks for your help.

Convert your date string into an internal format date using StringToDate() function, then to the number of days from a given day zero - from which you can perform "day arithmetic".

Sounds like a job for the DaysSinceFromDate function.

Thanks Ray and Craig. But the source table data type is date, then we don't need to use STRINGTODATE right?

Correct... check the function I posted, it returns the number of days between two dates.

Perfectly worked. Many thanks....