Date Arithmetic inDatastage

[amit_dwh]

Hi All

i have to subtract/add one/or more days from current date in transformer stage.
wht is the function or proper syntax to do this in datastage PX.

Thanks
Amit

[koolnitz]

You can use CurrentDate() function.
To add n days to current date, use CurrentDate() + n
To subtract n days from current date, use CurrentDate() - n

This fuction is even listed in Functions> Date & Time in derivation field in Transformer.

[vijayrc]

You can use CurrentDate() function.
To add n days to current date, use CurrentDate() + n
To subtract n days from current date, use CurrentDate() - n

This fuction is even listed in Functions> Date & Time in derivation field in Transformer.

In the sameline, with a date in yyyy-mm-dd available, how can I get the day part of Julian Day [yyyyddd]. Any direction in this is appreciated. Thankz

[ray.wurlod]

[THREAD HIJACK!!!]

Please start a new thread for this question. It is not related to the topic of this thread.

[mgendy]

You can use CurrentDate() function.
To add n days to current date, use CurrentDate() + n
To subtract n days from current date, use CurrentDate() - n

This fuction is even listed in Functions> Date & Time in derivation field in Transformer.

i try to use the above method , but it gives compile error

Error in output column derivation expression for column DWH_Entry_Date in link J_000_MLI_BILL_I_lk4. Invalid conversion requested from a dfloat to a date.

Kindly advice

[ray.wurlod]

Prefer DateFromDaysSince() function.