add number of months to date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I have a cycle count number field and would like to add this value to a date
of manufacture field to calculate expiry date
eg if cyclecount is 24 and manufacture date is 01/08/2005 i would like field
expiry date to equal aug 2007
I have been trying various formulas but can't get correct
thanks for any help
Tina
 
Thanks Dennis
I tried that about 2 hours ago but forgot the "" around the m
Hope to have a better day tomorrow
Thanks again
Tina

Dennis said:
[Expiry Date] = DateAdd("m",[CycleCount],[Manufacture Field])

tina said:
Hi
I have a cycle count number field and would like to add this value to a date
of manufacture field to calculate expiry date
eg if cyclecount is 24 and manufacture date is 01/08/2005 i would like field
expiry date to equal aug 2007
I have been trying various formulas but can't get correct
thanks for any help
Tina
Click to expand...
Click to expand...
 
This is definitely what I am after, but being new to all this (other than the
very basics, this is my first database).

[Expiry Date]=DateAdd("m",[Months to Expiry],[Issue Date]) is the exact code
I am using. But where to I enter this code?

Thanks in advance


tina said:
Thanks Dennis
I tried that about 2 hours ago but forgot the "" around the m
Hope to have a better day tomorrow
Thanks again
Tina

Dennis said:
[Expiry Date] = DateAdd("m",[CycleCount],[Manufacture Field])

tina said:
Hi
I have a cycle count number field and would like to add this value to a date
of manufacture field to calculate expiry date
eg if cyclecount is 24 and manufacture date is 01/08/2005 i would like field
expiry date to equal aug 2007
I have been trying various formulas but can't get correct
thanks for any help
Tina
Click to expand...
Click to expand...
Click to expand...
 
Back
Top