Trying to code "Age of Account"

[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?

 

[taps54]

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

 

[Dale Fye]

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

 

[1encapdiva]

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.

 

[1encapdiva]

I'll try that.
--
bhsvixon

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

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?

 

[John W. Vinson]

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.

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?

 

[1encapdiva]

Yes, thank you so much!!!
--
bhsvixon

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.

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?