Skip to main content

We are trying to get the number of days an invoice is outstanding.  I am trying to use  =((=ARInvoice.DRSchedCntr]) - Today()) to get the numbers of days, but I get an error.  What would be a better formula?

Hi @MComan62! You could use something like DateDiff() to get the difference between these two dates.

=DateDiff(‘d’, Today(), yARInvoice.DRSchedCntr])

Have you already tried this?

Have you tried using DateDiff().  You could try:

=CDec( DateDiff( 'd',  ARInvoice.DueDate], Today()) )

 

Robert, thank you.  I had tried DateDiff with no success.  I gotta learn all these syntax someday.

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