Skip to main content
Solved

GI condition to display results timestamped within the past 6 hours


Forum|alt.badge.img+1

I’m trying to use the SOShipment.ConfirmedDateTime field as a condition in a GI to show all shipments that were confirmed within the past 6 hours. i.e. Between Now()-6hrs AND Now()

Anyone know if this is possible?

Best answer by aaghaei

Use the below filter

Data Field: SOShipment.ConfirmedDateTime

Condition: Is Greater Than or Equal To

Value 1: =DateAdd(Now(), 'h', -6)

or if you want UTC time then

Value 1: Value 1: =DateAdd(NowUTC(), 'h', -6)

View original
Did this topic help you find an answer to your question?

3 replies

aaghaei
Captain II
Forum|alt.badge.img+9
  • Captain II
  • 1176 replies
  • Answer
  • May 1, 2023

Use the below filter

Data Field: SOShipment.ConfirmedDateTime

Condition: Is Greater Than or Equal To

Value 1: =DateAdd(Now(), 'h', -6)

or if you want UTC time then

Value 1: Value 1: =DateAdd(NowUTC(), 'h', -6)


Forum|alt.badge.img+1
  • Author
  • Semi-Pro II
  • 228 replies
  • May 1, 2023

Thanks, @aaghaei! I was circling around that answer, and it turned out to be simpler than I was trying to make it.


aaghaei
Captain II
Forum|alt.badge.img+9
  • Captain II
  • 1176 replies
  • May 2, 2023

Glad it worked. cheers


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings