Skip to main content
Solved

Days invoice outstanding

  • 21 March 2023
  • 3 replies
  • 90 views

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?

3 replies

BenjaminCrisman
Rank
Userlevel 7
Badge +4

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

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

Have you already tried this?

Robert Sternberg
Rank
Userlevel 7
Badge +8

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

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

 

Robert Sternberg, Crestwood Associates -- If a community member helped you, please *Like* their post/reply. If they provided an answer to your question, please mark it as *Best Answer*.
M
Rank
Userlevel 3
Badge

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

Michael Coman

Reply


Terms & ConditionsCookie settings