finding difference between date/time

[Former Member]

Hi All,

I am trying to find the difference between sales order create date and actual goods issue date .I have this information coming from 2 different DSO i.e. Sales Item and Delivery.Also these dates do not have the time stamp with them and I need to use additionally one more infoobject called 0crea_time to get the time stamp information.

I have decided to build one more DSO on top of these 2 and then find the difference between dates. Is this possible?Can I access both the DSO's from one of the transformation rules[as I need 2 transformation rules for populating this new DSO, one for delivery and other for Sales Item] for finding the difference between the dates?

Appreciate any inputs on this.

Thanks

Pradeep

Message was edited by:

Pradeep bm

[Former Member · Accepted solution]

don't understand why you need the timestamp for. I would recommed you creating a second dso and store the agi date in the cube do the difference at report runtime

Thanks

Wond