Trying to add advanced date display

  • Thread starter Thread starter Louis Herndon
  • Start date Start date
L

Louis Herndon

Hello,

I have developed a simple yet functional access database.
One of the forms is regarding our agency laptop service
requirements. We wish for our users to send in their
laptops every 60 days for service, updates, etc. There
are several things I wish to do. First I have a date/time
text label that works fine. I want to add another which
basically calculates the date plus 60 days.... how do i
accomplish this, ie; (First label shows current date/time,
Second label under the first should say "Date in 60 days:
____________). Also I want to set up an automailer, based
on a couple of the fields from the form, user's email and
the date of service. The automailer should send them an
access report basically saying they need to schedule
service. How can I accomplish this as well? Any help
would be greatly appreciated.
 
Hello,

I have developed a simple yet functional access database.
One of the forms is regarding our agency laptop service
requirements. We wish for our users to send in their
laptops every 60 days for service, updates, etc. There
are several things I wish to do. First I have a date/time
text label that works fine. I want to add another which
basically calculates the date plus 60 days.... how do i
accomplish this, ie; (First label shows current date/time,
Second label under the first should say
= "Date in 60 days: ____________).
Also I want to set up an automailer, based
on a couple of the fields from the form, user's email and
the date of service. The automailer should send them an
access report basically saying they need to schedule
service. How can I accomplish this as well? Any help
would be greatly appreciated.
Click to expand...

You can determine a date 60 days into the future several ways.

=[DateField] + 60
Or..
=DateAdd("d",60,[DateField])

So the second 'label' (It should be an unbound Text Control) should
have as it's control source:
="Date in 60 days: " & [Format([DateField] + 60,"mm/d/yyyy")

"Date in 60 days: 9/6/2004"

This date need not be saved in the table. Whenever you need the
information, simply repeat the calculation.
 
Back
Top