Trying to get the time difference from when a sales order was created and when it was shipped. The only function I could get was DateDiff. Is it possible to get the time in the format of “HOUR:MINUTE”?
=DateDiff( 'MINUTE',[SOShipment.ConfirmedDateTime],[SOOrder.CreatedDateTime])*-1
Best answer by BenjaminCrisman
View original
Was thinking of using MOD to achieve what I want as follows
Use this to get hours =DateDiff( 'HOUR', [SOOrder.OrderDate],[ARInvoice.CreatedDateTime],)
And this one to get the minutes.
DateDiff( 'MINUTE', [SOOrder.OrderDate],[ARInvoice.CreatedDateTime],)%60)
The issue is now on how to combine the two. Will appreciate any suggestions on how to achieve this.
+17
Hi
Can you please share the GI, so that I can build a SQL view and then create GI accordingly with the HH:MM:SS
+4
=Concat(Cstr(DateDiff('h', [SOOrder.OrderDate], [ARInvoice.CreatedDateTime])+':'+Cstr(DateDiff('n', [SOOrder.OrderDate], [ARInvoice.CreatedDateTime]))
Or did I misunderstand and you just want to SUM them into minutes or hours?
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.