Currentdate-1 ?

swades · Post by **swades** » Wed Jan 31, 2007 2:58 pm

Hi,

Can anyone help me how to calculate currentdate()-1 ?

Thanks

DSguru2B · Post by **DSguru2B** » Wed Jan 31, 2007 3:05 pm

Where do you want to do that, in DataStage? or in a database stage?

swades · Post by **swades** » Wed Jan 31, 2007 3:08 pm

I want to do this in Datastage.

Thanks

paddu · Post by **paddu** » Wed Jan 31, 2007 3:11 pm

here you go to use in transformer

OCONV(ICONV(@Date,"D4-YMD[4,2,2]")-1,"D4-YMD[4,2,2]")

Change the format to meet your requirement

I_Server_Whale · Post by **I_Server_Whale** » Wed Jan 31, 2007 3:13 pm

paddu wrote:here you go to use in transformer

OCONV(ICONV(@Date,"D4-YMD[4,2,2]")-1,"D4-YMD[4,2,2]")

Change the format to meet your requirement

Paddu,
Iconv and Oconv aren't available in PX.

swades · Post by **swades** » Wed Jan 31, 2007 3:15 pm

Thanks

I want that in PX.

Thanks

DSguru2B · Post by **DSguru2B** » Wed Jan 31, 2007 3:23 pm

You can do it inside the transformer. Something like

DateFromJulianDay(JulianDayFromDate(DSJobStartDate) -1)

swades · Post by **swades** » Wed Jan 31, 2007 3:37 pm

Thanks you very much

I used

DateFromJulianDay((JulianDayFromDate(CurrentDate())-1))

It works fine

Thanks again.

I_Server_Whale · Post by **I_Server_Whale** » Wed Jan 31, 2007 3:49 pm

swades wrote:Thanks you very much

I used
Code: Select all
DateFromJulianDay((JulianDayFromDate(CurrentDate())-1)) 
It works fine

Thanks again.

I think you can remove the extra pair of parenthesis.

DateFromJulianDay(JulianDayFromDate(CurrentDate())-1)

paddu · Post by **paddu** » Wed Jan 31, 2007 4:31 pm

sorry overlooked