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?
Answer
GI condition to display results timestamped within the past 6 hours
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)
+10Use 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*.
Thanks,
+10Glad 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*.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.