Hi,
How to do Date Arithmetic in Parallel ? Say Incrementing Input Date Fields by 1. When i tried to use DateFromDaysSince i got the following compiler error...
##E TFCP 000007 11:48:30(001) <transform> Error when checking composite operator: Parsing parameters "" for conversion "date=date_from_days_since[**********](int32)": APT_Conversion_Date_DaysSince: Invalid Date [] used for date_from_days_since type conversion
##E TFCP 000007 11:48:30(002) <transform> Error when checking composite operator: Parsing parameters "" for conversion "date=date_from_days_since[**********](int32)": APT_Conversion_Date_DaysSince: Invalid Date [] used for date_from_days_since type conversion
##E TFSR 000019 11:48:30(003) <main_program> Could not check all operators because of previous error(s) (TestRead.Transformer_192)
Transformer Code...
If RunningDt = StringToDate("01/01/1900","%mm/%dd/%yyyy") then DateFromDaysSince(1,StringToDate("01/01/1900","%mm/%dd/%yyyy") ) else
DateFromDaysSince(2, StringToDate("01/01/1900","%mm/%dd/%yyyy"))
Thanks in advance.
Raj.
Date Arithmetic
Moderators: chulett, rschirm, roy
Re: Date Arithmetic
rggoud wrote:Hi,
How to do Date Arithmetic in Parallel ? Say Incrementing Input Date Fields by 1. When i tried to use DateFromDaysSince i got the following compiler error...
Raj.
GOT ANSWER FOR UR PROBLEM.?? ..IF NOT JUST MAIL ME. I HAVE THE ANSWER FOR THIS QUESTION.
date arithmetic
hi ArndW,ArndW wrote:dxp,
why don't you post the answer so that others are helped?
It looks like the first DateFromDaysSince() function has an invalid first argument, '1' is not a date.
my machine was giving some problems, so late reply...
initial value of testdate1=2005-06-01
testdate2:int32=days_since_from_date["2005-05-01"](testdate1)------->(in Modify Stage...Specification property)
testdate3=testdate2+1-------->(in Transformer Stage)
testdate4:date=date_from_days_since["2005-05-01"](testdate3)------->(in Modification Stage........Specification Property)
testdate4=2005-06-02-------------->(final output....date increased by 1-day)
Note:-in place of quoted date..."2005-05-01"...any value of this format can be given. it works. output wont be wrong.
...dxp.