Elapsed days invoice aging
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: ...
Forum Discussion
Try this:
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!
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!
Actually - I get an error in my test app if I use ToDate with a Date field - "Formula error -- Bad or missing arguments in function call".
This is assuming that [Date Invoice Sent to Client] is a Date field.
I'm surprised it worked for you in your test app? I'm not seeing the same thing for some reason.
This is assuming that [Date Invoice Sent to Client] is a Date field.
I'm surprised it worked for you in your test app? I'm not seeing the same thing for some reason.