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?
Answer
Days invoice outstanding
Best answer by Robert Sternberg
Have you tried using DateDiff(). You could try:
=CDec( DateDiff( 'd', [ARInvoice.DueDate], Today()) )
+4Hi
=DateDiff(‘d’, Today(), [ARInvoice.DRSchedCntr])
Have you already tried this?
+7Have 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*.
Robert, thank you. I had tried DateDiff with no success. I gotta learn all these syntax someday.
Michael Coman
Can someone assist me with adding a style to this row so that if an invoice is past due it shows up in a color on the report?
Thank you.
+4
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.