Date

[ramisetti]

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.

[swades]

Try this:

Code: Select all

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

[ray.wurlod]

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.

[laxmi_etl]

It is working

Thanks