calculating "payment due date"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My database has the date a subscription started, the subscription period is one year. I want to be able to
1) determine subscription due dat
3) be able to filter or query the subscriptions that are due that mont

In addition, I would like to be able to identify which subscriptions are 30, 60 90+ days past due

Thank you!!!
 
1. Use the DateAdd function to get the date 1 year from the subscription start
date
3. Use the month function on values in 1 to get the month subscriptions are due
4. Use the DateAdd and Date functions to get your past due subscriptions

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


Kimberli said:
My database has the date a subscription started, the subscription period is
Click to expand...
one year. I want to be able to:
 
My database has the date a subscription started, the subscription period is one year. I want to be able to:
1) determine subscription due date
3) be able to filter or query the subscriptions that are due that month

In addition, I would like to be able to identify which subscriptions are 30, 60 90+ days past due.

Thank you!!!
Click to expand...

Create a Query based on your table. In a vacant Field cell put a
calculated field:

DueDate: DateAdd("yyyy", 1, [SubsDate])

(or whatever the name of your subscription date is).

You can put criteria on this field of

BETWEEN Date() AND DateAdd("m", 1, Date())

to get the upcoming month's renewals, or

BETWEEN DateSerial(Year(Date()), Month(Date()), 1) AND
DateSerial(Year(Date(), Month(Date()) + 1, 0)

for the current monthe (March 1 - 31 if it were run today).

Between DateAdd("d", -30, Date()) AND DateAdd("d", -59, Date())

as a criterion will get subscriptions 30 to 59 days overdue... the
rest should be obvious!
 
Back
Top