Solved

GI condition to display results timestamped within the past 6 hours

M
Rank
Userlevel 5
Badge +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?

icon

Best answer by aaghaei 2 May 2023, 00:15

View original

3 replies

aaghaei
Rank
Userlevel 7
Badge +9

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)

Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
M
Rank
Userlevel 5
Badge +1

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

aaghaei
Rank
Userlevel 7
Badge +9

Glad it worked. cheers

Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.

Reply


Terms & ConditionsCookie settings
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