Calculation in Stage Variable

sam334 · Post by **sam334** » Wed Apr 22, 2015 3:02 pm

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.

ray.wurlod · Post by **ray.wurlod** » Wed Apr 22, 2015 3:11 pm

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".

chulett · Post by **chulett** » Wed Apr 22, 2015 3:11 pm

Sounds like a job for the DaysSinceFromDate function.

sam334 · Post by **sam334** » Wed Apr 22, 2015 3:17 pm

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

chulett · Post by **chulett** » Wed Apr 22, 2015 9:23 pm

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

sam334 · Post by **sam334** » Thu Apr 23, 2015 10:58 am

Perfectly worked. Many thanks....