End Date Calculation

maffan76 · Post by **maffan76** » Sat May 06, 2006 1:50 pm

hi,
I have 2 columns Date, Time and third column contains duration. i want to calculate the end date time based on these 3 columns. Can someone please throw some light to how to accomplish it efficiently as i ahve to process large amount of data. Also hows does PX internally manipulates the Datetime data.

p.s.
Is is possible to convert everything in Seconds and then adding the duration and convert it back to timestamp?

Thanks in advance.

dwandbi · Post by **dwandbi** » Sat May 06, 2006 9:07 pm

convert the duration into number of days and add them to date in datetime format and this becomes the end date in your case. Make sure in what format the duration exists in your case.

maffan76 · Post by **maffan76** » Sun May 07, 2006 12:19 am

hi,
The duration is in Seconds and want to calculate the end date based on that.

maffan76 · Post by **maffan76** » Sun May 07, 2006 4:56 am

hi
Done it using TimestampFromDateTime & TimestampFromSecondsSince. The only question left is that is this an efficient way of calculating the end datetime?

dwandbi · Post by **dwandbi** » Sun May 07, 2006 11:23 am

Untill unless you are getting correct end date for all different combinations, your way of calculation is correct,

thanks,
Tom

kumar_s · Post by **kumar_s** » Mon May 08, 2006 5:07 am

If you concern is more into processing efficiency you may try using Modify stage instaed of transofmer stage.
You can find the simila funciton avialable there.

Code: Select all

timestamp_from_seconds_since[timestamp](dfloat)
timestamp_from_date [time](date)
timestamp_from_time

maffan76 · Post by **maffan76** » Mon May 08, 2006 5:36 am

But i have to transform the other columns as well i-e applying business rules to other columns, so is it a good idea to put the modify stage and then pass the data to transformaer for applying the business rules.

Also whats the best practice for the situation where mix of rules exist e.g. Data type Conversions, Date Claculations, Applying calculations.

Thanks in advance.

kumar_s · Post by **kumar_s** » Mon May 08, 2006 6:01 am

If there is a need of transformer, it is always advisalbe to accomplish all the logic in the same stage (not overloaded) inorder to avoid the additional buffering of data, memory usage, disk usage (IO).