Skip to main content
Solved

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

  • Mar 14, 2024 4:29 AM UTC
  • 3 replies
  • 218 views
  • Translate All

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.

 

 

View original

3 replies

Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Answer
  • Mar 14, 2024 4:51 AM UTC

@thanuja28 

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

 

 

Translate

  • Author
  • Freshman I
  • Mar 14, 2024 5:56 AM UTC

Hi @Naveen Boga 

 

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

 

Translate

Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Mar 14, 2024 5:57 AM UTC

@thanuja28  Awesome! Thanks for sharing the update!

Translate