Skip to main content
Answer

Unable to use Date Diff on SOOrder.RequestDate and AMProdItem.EndDate

  • September 29, 2022
  • 2 replies
  • 112 views
A
Jr Varsity II

I am trying to find date variance between SO Request Date and AM prod Item End date. 
This is the formula I have coded: =DateDiff( d,[SOOrder.RequestDate] , [AMProdItem.EndDate] )

I get the following error : 


Any help is appreciated.

Best answer by Manikanta Dhulipudi

I am trying to find date variance between SO Request Date and AM prod Item End date. 
This is the formula I have coded: =DateDiff( d,[SOOrder.RequestDate] , [AMProdItem.EndDate] )

I get the following error : 


Any help is appreciated.

Check this once I  =DateDiff('d',[SOOrder.RequestDate] , [AMProdItem.EndDate] ) 

I tested simple GI with formula ( But different fields) may be you can check in report

C

2 replies

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+15

I am trying to find date variance between SO Request Date and AM prod Item End date. 
This is the formula I have coded: =DateDiff( d,[SOOrder.RequestDate] , [AMProdItem.EndDate] )

I get the following error : 


Any help is appreciated.

Check this once I  =DateDiff('d',[SOOrder.RequestDate] , [AMProdItem.EndDate] ) 

I tested simple GI with formula ( But different fields) may be you can check in report

1 Attachments
Acumatica Functional Consultant & Customer Experience Supervisor
Manikanta Dhulipudi
Chris Hackett
A
Jr Varsity II
  • adalvi
  • Author
  • Jr Varsity II
  • September 29, 2022

Oh my bad. I am so silly :P 
Forgot the ‘ ‘ for the interval. Thank you so much @manikantad18 .

Manikanta Dhulipudi
Chris Hackett
Terms & ConditionsCookie settingsAccessibility statement
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