Modify Stage- DaysSinceFromDate syntax

venkat_kp · Post by **venkat_kp** » Sat Feb 17, 2007 12:53 pm

I am trying to count the of days between the Transaction date and the date posted. What is the correct syntax for the modify stage.

NumofDays = DaysSinceFromDate (DatePosted,TransDate)

Thanks.

ray.wurlod · Post by **ray.wurlod** » Sat Feb 17, 2007 2:29 pm

Code: Select all

NumDays:integer=days_since_from_date[source_date](date)

DaysSinceFromDate() is a Transformer stage function, not a Modify stage function.

luie · Post by **luie** » Tue Mar 20, 2007 12:23 pm

Does the source_date argument of days_since_from_date function accept only hard-coded value? I want to use it but when I pass a date column for source_date, I get the following error. It works though if I use a hard-coded date like "2007-01-01" but this is not the way I want it.

NEW_DATE and TRANSACTION_DATE are my arguments which are both date columns.

-------------------------------------------------------------------------
main_program: Error parsing modify adapter: Error in binding: Parsing parameters "NEW_DATE" for conversion "int32=days_since_from_date[**********](date)": APT_Conversion_DaysSince_Date: Invalid Date [NEW_DATE] used for days_since_from_date type conversion
Expected destination field selector, got: ")"; input:
DIFF = days_since_from_date[NEW_DATE] (TRANSACTION_DATE)
;
[sil/step_il.C:3446]

ray.wurlod · Post by **ray.wurlod** » Tue Mar 20, 2007 6:14 pm

In Modify stage functions can take only one argument.

In days_since_from_date() the source date must be a constant. It can not be an input column.

ag_ram · Post by **ag_ram** » Tue Mar 20, 2007 10:20 pm

venkat_kp wrote:I am trying to count the of days between the Transaction date and the date posted. What is the correct syntax for the modify stage.

NumofDays = DaysSinceFromDate (DatePosted,TransDate)

Thanks.

if you are looking for the transformer function , here is a sample of how to use that
DaysSinceFromDate(Inputcol.EffDate, DateToString(CurrentDate(),"%yyyy-%mm-%dd"))

ray.wurlod · Post by **ray.wurlod** » Tue Mar 20, 2007 10:32 pm

Given the original request

venkat_kp wrote:What is the correct syntax for the modify stage.

I do not believe the OP was looking for the Transformer stage function.

gbusson · Post by **gbusson** » Wed Mar 21, 2007 10:17 am

this founction exist in a modify stage. In the modify, the 2nd parameter must be a constant, not in the transformer.

In the transformer, if the 2nd paramter is not a constant, performance is very poor!

DSguru2B · Post by **DSguru2B** » Wed Mar 21, 2007 10:29 am

gbusson wrote: In the transformer, if the 2nd paramter is not a constant, performance is very poor!

The performance has been drastically improved in all 7.x versions. Hence you cannot claim that transformer is "very poor" in performance, unless your using a version lower than 7.x. It still cannot beat modify stage, so I have heard, but its come a long way.

gbusson · Post by **gbusson** » Wed Mar 21, 2007 10:32 am

i used it with 7.0, and it is poor!

my solution : difference between the daysfom the constant and the 2 columns

gbusson · Post by **gbusson** » Wed Mar 21, 2007 10:33 am

This function is poor, not the transformer! Well used, it is a very powerful stage!

DSguru2B · Post by **DSguru2B** » Wed Mar 21, 2007 10:34 am

O ok. For some reason I thought the transformer was under attack, yet again.

gbusson · Post by **gbusson** » Wed Mar 21, 2007 10:36 am

In France, IBM/Ascential consultants attack in their best practice,

but experience shows that it is not justified.

DSguru2B · Post by **DSguru2B** » Wed Mar 21, 2007 10:39 am

Thats the very reason I wanted to give my 2 cents on transformer. But it all sprung from a misunderstanding.
Cheers.

gbusson · Post by **gbusson** » Wed Mar 21, 2007 10:48 am

It is not useless, it was a useful chat!

See you!

DSXchange

Modify Stage- DaysSinceFromDate syntax

Modify Stage- DaysSinceFromDate syntax

Re: Modify Stage- DaysSinceFromDate syntax