Follow-up Dates formulas

flipper · Mar 14, 2006

How do I enter a formula/calculation in a table for follow up dates. I have a basic start date. In my form/table, I want the program to insert the following follow up dates automatically: one month, 3 month and 6 month.

Charmed7 · Mar 15, 2006

I'm not an expert

but it I had to do something, I would create a macro to do it. Not sure if that was helpful though. And if you need any help with that let me know.

raskew · Mar 16, 2006

Hi -

It's not considered good programming practice to store dates that can be calculated 'on the fly' with a query. If the original date were to change for any reason, then the calculated dates would be incorrect and you'd need to have another procedure to catch and fix the discrepancies.

As far as creating the calculation, you'd use the DateAdd() function. Here's a sample query that returns the 1,3 & 6 month dates, based on the OrderDate from Northwind's Orders table.

Code:

SELECT
    Orders.OrderID
  , Orders.OrderDate
  , DateAdd("m",1,[OrderDate]) AS OneMonth
  , DateAdd("m",3,[OrderDate]) AS ThreeMonth
  , DateAdd("m",6,[OrderDate]) AS SixMonth
FROM
   Orders;

HTH - Bob

Follow-up Dates formulas

flipper

Guest

Charmed7

Registered User.

raskew

AWF VIP

Similar threads

Users who are viewing this thread