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
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
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?