Getting date -1 value

ethanr · Post by **ethanr** » Tue Sep 30, 2008 6:00 am

Hi

I am passing a date parameter(22-10-2008) as an input to a column. I need, output as given date -1. I tried
date -1 in transformer stage, but job not getting compiled. Is this not the right way to get DATE -1 . How can this be achieved.

Thanks

ray.wurlod · Post by **ray.wurlod** » Tue Sep 30, 2008 6:47 am

DateFromDaysSince() function

ArndW · Post by **ArndW** » Tue Sep 30, 2008 6:51 am

Your input parameter date is a string. In a transform stage, preferably in the stage variables, convert the string to a date. Then apply the DateFromDaysSince() function to the date and use that in the transform. If you use the "initial value" for the stage variables then they will only be computed once, not for every row.