DSXchange

Posted: **Tue Apr 17, 2007 4:13 pm**

Hi,

I have a table 'X' with a field called 'B'
I need to pass next day date to the field 'B'
I have to do this in the Transformer what function I can use for this.

Is there any help on this

Thanks.

Posted: **Tue Apr 17, 2007 4:19 pm**

Try this:

Code: Select all

DateFromJulianDay((JulianDayFromDate(CurrentDate())+1))

Posted: **Tue Apr 17, 2007 6:18 pm**

The Transformer stage itself can not pass the date to the the table; it can calculate the date as swades indicates. But to pass it to the table you will need the appropriate database stage type. You will also need that the data type of column B is compatible with Date.

Posted: **Tue Apr 17, 2007 9:01 pm**

It is working

Thanks