DSXchange

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

DateFromDaysSince() function

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.