Transformer Date Calculations

[Kattrix]

In a iqd data source brought into Transformer 7.1, I have two dates... An order date and a delivery date. I need to calculate the number of days between the two dates.

I attempted to add a calculated column into the data source, but there is not an available function to do this. I also attempted the 'age' function on both and tried to subtract the values, but the expression editor would not let me do this.

Are there additional functions I can load into Transformer?


Katie McCray
MIS Project Analyst
Bush Industries Furn Mfg

 

[DoubleD]

Any reason why you're not calculating the date difference in your IQD? The calculation could happen on the database which should be much more efficient.

I am what I am based on the decisions I have made.

DoubleD

 

[Kattrix]

Nope. No reason... just writer's block this afternoon.
I added it to the iqd.

Thanks a million!!!


Katie McCray
MIS Project Analyst
Bush Industries Furn Mfg