Skip to main content
Question

Elapsed days invoice aging

  • April 16, 2019
  • 0 replies
  • 48 views

Forum|alt.badge.img+8
Well.... having some "developmental opportunities" again.

Trying to calculate days an invoice is aging after being sent (believe it or not we have net 90 with one customer).  I have two fields:

1.) [Days Aging] - Numeric formula
2.) [Date Invoice Sent to Client] - Date Field

Help provided is always sooooo appreciated!

------------------------------------------------------------------------------


formula syntax error

There are extra characters beyond the end of the formula.


ToDays(Today()-Todate([Date Invoice Sent To Client]))  ,





  • Registered
  • April 16, 2019
Is that the whole formula? The formula looks correct other than the comma on the end.

What issues are you having with it? If there is more to it as the comma suggests post that part because this looks right to me.

  • Registered
  • April 16, 2019
Try this:
ToDays( Today()-[Date Invoice Sent to Client] )

Notes:
- You had an extra comma at the end
- Since [Date Invoice Sent to Client] is already a Date field, you don't need to convert it with the "ToDate" function

Hope this helps!

Formula looks fine to me. Works in my test app. Pardon the question - you've reproduced it here with an errant trailing comma - is that character in your formula?

EDIT to clarify: this formula works if [Date Invoice Sent To Client] is a date/time or text field. It will NOT work if that field is a simple date field. However, if that were the issue you'd be seeing this error:
"Formula error -- Bad or missing arguments in function call"
rather than 
"Formula syntax error -- There are extra characters beyond the end of the formula"

Thanks to @Xavier Fan for narrowing that down

Forum|alt.badge.img+8
  • Author
  • Registered
  • April 18, 2019
Alex.... that worked just fine.  Thank you!

Dirk