Calculate Future Dates

[fay1136]

Help Help Help - I have a database which I need to calculate a date 3 years from now, then report on it 6 months before the 3 years expires...

Hope that makes sense

Fay1136

 

[KenHigg]

You should be able to get the date with date() + 1095. Then work the other stuff out from there...

Hope this helps.

 

[alastair69]

Fay,

Am i right in saying you have two problems.

1. Calulating the date in three years (Should it take into account Sat/Sun)
2. 6 months before the calulated review date you need a report to show the up coming review of this item.

Some times it is easier to break the problem down and address one at once.

Alastair

 

[alastair69]

Ken,

Why would you add 1095 onto the date()?

 

[fay1136]

Dates

Hi Alastair

That's exactly what I need to do, can you help?

Fay

 

[KenHigg]

Ken,

Why would you add 1095 onto the date()?

I read it as to start with he needed todays date plus three years. Did I miss something?

 

[alastair69]

Ken,
My misstake 1095 is the number of day plus say todays date would give a date of 27/12/2008.

Alastair

 

[alastair69]

Fay,

Are you using Todays date 02/02/2006, if so what is the textbox or combobox called that stores the information?

 

[KenHigg]

OK, I guessing that the main tables has a date fld, say a date of last review. 6 months before this date becomes 3 years old, you need to pull it up for review again. (?)

If so just do a query with a param on the date fld you do something like:

< Date() - 912

Would this work?

 

[Bat17]

wouldn't the dateadd function be better?
DateAdd("YYYY", 3, Date)

Peter