Trying to code "Age of Account"

  • Thread starter Thread starter 1encapdiva
  • Start date Start date
1

1encapdiva

Hi everyone,

I have a field where I want to calculate the age of a client's account based
on their admission date, payment, and balance. Does any one have any
suggestions?
 
What role do payment and balance have in determining the "age" of the
account? Or are you trying to determine how long it has been since their
latest payment so you can do some sort of 30/60/90 day thing?

Dale
 
That's it! I'm trying to determine how long it has been since the client's
last payment was made so I can do a 30/60/90 day collections letter.
 
I'll try that.
--
bhsvixon


taps54 said:
Try using Aging:date() -[admission date] in your query

1encapdiva said:
Hi everyone,

I have a field where I want to calculate the age of a client's account based
on their admission date, payment, and balance. Does any one have any
suggestions?
Click to expand...
Click to expand...
 
That's it! I'm trying to determine how long it has been since the client's
last payment was made so I can do a 30/60/90 day collections letter.
Click to expand...

You can put a calculated field in a query by typing

Age: DateDiff("d", [PaymentDate], Date())

to count the number of (calendar, not business) days between the value in the
field PaymentDate and today's date. Will that help?
 
Yes, thank you so much!!!
--
bhsvixon


John W. Vinson said:
That's it! I'm trying to determine how long it has been since the client's
last payment was made so I can do a 30/60/90 day collections letter.
Click to expand...

You can put a calculated field in a query by typing

Age: DateDiff("d", [PaymentDate], Date())

to count the number of (calendar, not business) days between the value in the
field PaymentDate and today's date. Will that help?
Click to expand...
 
Back
Top