Function to get difference in time

  • 23 November 2022
  • 2 replies

Userlevel 4

Couldn’t find the function to calculate difference in time between fields in generic inquiry ie

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 but it doesn’t return time only days

=DateDiff( 'd',[SOShipment.ConfirmedDateTime],[SOOrder.CreatedDateTime])*-1


Any suggestions in how to go along with this?


Best answer by Naveen Boga 23 November 2022, 11:35

View original

2 replies

Userlevel 7
Badge +17

Hi @development93  Can you please try below and verify.


=DateDiff( 'MINUTE', [SOOrder.CreatedDateTime] , [SOOrder.OrderDate])

Userlevel 4

Hi @development93  Can you please try below and verify.


=DateDiff( 'MINUTE', [SOOrder.CreatedDateTime] , [SOOrder.OrderDate])

Is it possible for it to be displayed in Hours and Minutes format?


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved