Multiply Date field

[coolcatkelso]

Hiya

I'm trying to multiply my Date field but its spitting out the wrong date.

I have the form like this

Date of Work Completed - Short Date - Data is 5 May 2009

Job Garanteed - Yes / No

Garentee Term - 5 (5 Years)

Garantee Expires - Blah So far its at 23/9/2446 (more than 5 years) lol

Formula I'm using is [Date of Work] * [Garantee Term]

If I use + instead of * it adds 5 days on, but not years? Its just the year I want to multiply by the term?

Any help?

CCK
________
Meth Rehab Forum

 

[Kiwiman]

howzit

You can use the dateadd function to add the 5 years to your job date

dateadd("y",yourGTfield,yourdate)

 

[coolcatkelso]

Cheers for the reply

Would this still allow the Garantee term to change? Not all jobs would be 5 years some can be as much as 10?
________
KID AVANDIA

 

[Kiwiman]

Howzit


The yourGTDate part of my example is the variable aspect of this dateadd funciton, and will add the number of years, you put in the Guaranteed Term field, to the job date.

 

[coolcatkelso]

Cool Thanks

So it would be like this

dateadd("y",Garantee Term,Date of Work)
________
Babe blonde

 

[Kiwiman]

Howzit

It may very well be yyyy not y, but yes that is the format