adding 6 months to a date

[Acehole]

hi all,
first timer on here so be nice, I have a form and on said form I have a date that has been entered, lets say todays date. how do I add 6 months to this date and display It on the form?
thanks I advance
Acehole

 

[dmt32]

Hi,
One way would be to use the DateAdd Function - you can find more about it in the VBA Helpfile & further guidance here:MS Excel: DATEADD Function (VBA)

Hope Helpful

Dave

 

[alansidman]

In another textbox control, use the expression =DateAdd(Interval, Number, Date). Look at this link for further information on this expression.

MS Access: DateAdd Function

 

[Acehole]

hello and thanks for the replies
I have a field on my table with a date In it, how do I auto populate the next field with a date six months from the previous date field, the field is called LastCall and has date in it. the next field is called NextCall I want this to populate with a date six month after LastCall date if that makes sense
regards
acehole

 

[alansidman]

in the field type =DateAdd("m",6,[LastCall])

 

[Acehole]

hi there, thanks for the reply,
however when I put that I the field nothing happens ?it stays there as text?
thanks
acehole

 

[Acehole]

hello apologies for the bump, anyone got any idea?
regards
acehole

 

[Joe4]

hi there, thanks for the reply,
however when I put that I the field nothing happens ?it stays there as text?

Where exactly are you putting it?
Are you putting it in the Control Source of an Unbound field on your Form?

 

[Acehole]

hello,
thanks for the reply, I can get it to give me the date on the form, was trying to populate the table.
regards acehole

 

[Joe4]

thanks for the reply, I can get it to give me the date on the form, was trying to populate the table.

General rule of thumb: there is seldom a reason to store a value which can be calculated in an underlying table. If you can calculate it at anytime, there is usually no reason to store it (and doing so could actually violate the rules of Database Normalization and undermine the integrity of your database).

What do you think you need to store it instead of just calculating it when needed?