Formula help

[fantaman]

Hi,

I am trying to subtract dates that are coming from the same field and need a formula to have them calculate correctly. I have a field that records the date whenever an order is shipped. If an order is shipped short, a backorder is generated and the order is shipped again.

I would like to know the difference in hours between the date the original order was shipped and the date the backorder was shipped. I am familiar with using the date differential to subtract different fields, but how can I set this up when it is the same field?

Thanks for your help.

 

[synapsevampire]

It sounds like you understand CR well enough, so I'll summariaze the approaches.

Group by the Order, and then you have options, such as comparing the difference between each record (in the instance of multiple back-orders) by using the previous() or next() functions, or you can just get the minimum and maximum within the order and do your compare against them.

-k