Solved

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

  • 29 September 2022
  • 2 replies
  • 90 views
A
Rank
Userlevel 1

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.

icon

Best answer by manikantad18 29 September 2022, 17:06

View original

2 replies

manikantad18
Rank
Userlevel 7
Badge +12

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 Attachment
Acumatica Functional Consultant
A
Rank
Userlevel 1

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

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