previous date

vinsashi · Post by **vinsashi** » Thu Oct 20, 2011 12:51 am

i want to extract previous timestamp from current timestamp filed in datastage PX.

Thanks
v......

deeplind07 · Post by **deeplind07** » Thu Oct 20, 2011 12:56 am

can you please explain in detail?

vinsashi · Post by **vinsashi** » Thu Oct 20, 2011 1:09 am

in my source file i am getting date columns and for target i should pass previous date for those columns.

ex:
frezdate
10/01/2010
01/03/2010

output:
09/01/2010
27/02/2010

like this i want output just previous date i should load for each record.

prasson_ibm · Post by **prasson_ibm** » Thu Oct 20, 2011 1:45 am

Hi,

In transformer you can do the derivation in this way:-

DatefromJulianDay(Juliandayfrom date(Input.date)-1))

I think it should work.

Thnaks

Prasoon

deeplind07 · Post by **deeplind07** » Thu Oct 20, 2011 4:38 am

I am not sure as i dont have datastage access now, but you can try using 'column_name - 1' directly in trnsformer

chulett · Post by **chulett** » Thu Oct 20, 2011 7:23 am

That won't work, I'm afraid.

Another solution - research the use of the DateFromDaysSince function.

ray.wurlod · Post by **ray.wurlod** » Thu Oct 20, 2011 2:53 pm

TimestampFromSecondsSince() function with an offset of -86400 should also work.

DSXchange

previous date

previous date

Re: previous date