First some assumptions...
1. The field that you are storing it in is of type "Date" rather than
type "Text".
2. You want the same day number of the month. jan 1 to june 1... not 180
days.
DateAdd(m, 6, [Open Date])
[Open Date] is the field that has the start date.. You may need to fully
qualify the field. If you use build and select the field it will do the
work for you.
Chris
Evelyn Pabón wrote:
Hi
I built a database application and I have a field which is for the Close
Date. But I need to create an effective date that it will come out
automatically. The Effective Date should be 6 months after the Close Date.
How can I do this?
Any help I would really appreciate it.
Thanks,
Ely