Access 2000 and calculating a deadline

  • Thread starter Thread starter Kyle Powderly
  • Start date Start date
K

Kyle Powderly

I am working on a database in which I need to "back-
calculate" dates, based on a date (month and year) input
by the user. Basically, what I need to do is subtract four
months from the input date, then have that read in
mm/dd/yyyy format where dd is the first of that month. I
haven't been able to figure a way to do that with the
built-in tools, nor do the books I have give me any
direction, and I know NO Visual Basic, so that doesn't
help...Help!
 
Make sure that the original date field is formated as a
date. I found it easiest to add a new field to the table
and label it "back date". Make sure that is is a date
format as well. Then make an update query. Bring in both
date fields. on the update line of the "back date" right
click and select build. Double click on "date" in the
middle box. Then simply do a - 120. If you have any
problems let me know. If you need this automated, just
set it up in a macro to run when ever you update or add a
record.
 
Back
Top