Skip to main content
Answer

Today's date and SO billing date difference (in days) in the GI Results Grid

  • March 14, 2024
  • 3 replies
  • 145 views
T
Freshman I

Hello Team, 

Is there any way to get the difference in days between Today's date and SO's billing date in the generic inquiry results grid?

Please advice on the steps. 

Thank you!

Best answer by Naveen Boga

@thanuja28 

You can use the DateDiff function in the GI to get both date differences. Hope the below screenshots will help you.

 

 

3 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Naveen Boga
  • Captain II
  • Answer
  • March 14, 2024

@thanuja28 

You can use the DateDiff function in the GI to get both date differences. Hope the below screenshots will help you.

 

 

Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
Chris Hackett
T
T
Freshman I
  • thanuja28
  • Author
  • Freshman I
  • March 14, 2024

Hi @Naveen Boga 

 

I was able to fix the issue by using this solution. Appreciate your quick support.

 

Naveen Boga
Chris Hackett
Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Naveen Boga
  • Captain II
  • March 14, 2024

@thanuja28  Awesome! Thanks for sharing the update!

Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
T
Terms & ConditionsCookie settingsAccessibility statement
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