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?
Days invoice outstanding
Hi
=DateDiff(‘d’, Today(), [ARInvoice.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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.