Solved

Function to get difference in time

  • 23 November 2022
  • 2 replies
  • 374 views

Userlevel 4
Badge

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?

icon

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
Badge

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?

Reply


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