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?
Best answer by Robert Sternberg
View original
+4
Hi
=DateDiff(‘d’, Today(), [ARInvoice.DRSchedCntr])
Have you already tried this?
+8
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.