Dates

[Emma]

Hi I'm trying to create a database which will have a table with many dates
all 3 months from initial date. Am I going about this correctly that I need a
separate table called Dates? And what would I store in this table? Client Id?
Any advice would be greatly appreciated. Thanks Emma

 

[Andy Smith]

You need to give a lot more information. What do clients and dates have to
do with each other? Maybe I can help with the dates: if you mean dates that
are 3 months, 6 months, 9 months, etc., from the initial date, you can use
the Year, Month and Day functions to extract the three parts, add 3, 6, 9,
etc. to the month part, and feed the three parts back to the DateSerial
function even if the revised month part is outside the range 1-12 --
DateSerial will adjust the year accordingly. In a one-line expression this
would be:

DateSerial(Year([initial]), 3*[increments] + Month([initial]), Day([initial]))