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
Getting date -1 value
Moderators: chulett, rschirm, roy
Getting date -1 value
Thanks, EthanR
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>