Subtracting 2 dates in Transformer

chulett · Post by **chulett** » Wed Oct 06, 2004 1:48 pm

Have some more tuna.

kcbland · Post by **kcbland** » Wed Oct 06, 2004 1:53 pm

Uuugghh Diets suck. Watching me on the treadmill is like watching a walrus try to hoola hoop. Not pretty.

pkl · Post by **pkl** » Wed Oct 06, 2004 2:22 pm

Hi,

If you are not frustrated with me till now , well... you will now

because I was making a very silly mistake.

I enclosed the DSLink.Date1 in quotes , I had to put the values as
Iconv(DSLink.Date1[1,10],'DYMD') instead I did
Iconv('DSLink.Date1[1,10]','DYMD') .

I greatly appreciate all your help. Thanks a lot.

Regards
Preethi

kcbland · Post by **kcbland** » Wed Oct 06, 2004 2:35 pm

Rats, no donut.

JDionne · Post by **JDionne** » Wed Oct 06, 2004 2:51 pm

JDionne Tosses Kcbland a tofu donut

enjoy

hiral.chauhan · Post by **hiral.chauhan** » Thu Mar 26, 2009 4:56 pm

Probably most people know this by now, but there's an easier way to subtract dates in transformer (not BASIC transformer.. the one in 8.1.0)

DaysSinceFromDate(CurrentDate(),DSLink21.PROD_DT)

Result = 26

In my example CurrentDate() is 3/26/2009 and DSLink21.PROD_DT = 2/28/2009

(There was actually a function to do this!!! lol..

and I was going through Iconv and Oconv.. and BASIC.. )

Hope this saves time for any other newbie like me

Cheers !!

Hiral

chulett · Post by **chulett** » Thu Mar 26, 2009 5:03 pm

Maybe so, but this is a discussion in the Server Edition forum on how to do this in a Server job, not a Parallel job.

hiral.chauhan · Post by **hiral.chauhan** » Thu Mar 26, 2009 5:36 pm

chulett wrote:Maybe so, but this is a discussion in the Server Edition forum on how to do this in a Server job, not a Parallel job. ...

My bad ! now I see why I did not find this topic anywhere else..

DSXchange

Subtracting 2 dates in Transformer

Subtracting dates in Transformer