I have the following formula  DATEDIF(Due Date, Invoice Date, D) in a connector Excel formula expression.  The Invoice Date and Due Date are SQL expressions like this CAST(CAST([APOBS].[DATEINVC] AS varchar) AS datetime).  When I run the report I get #value in the resulting column in Excel. How can I get the difference between two different Dates using Sage 300. 

Views: 124

Reply to This

Replies to This Discussion

Hi Lloyd.

Take a look at the below example I implemented using a SQL expression.


The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service