Skip to main content

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?

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)

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

Glad it worked. cheers

Reply


Terms & ConditionsCookie settings