Help - Close Date and Effective Date

[Evelyn Pabón]

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

[PC Datasheet]

Re: Help - Close Date and Effective Date

Ely,

Look at the DateAdd function in the Help file.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@pcdata sheet.com

https://www.pcdatasheet.com

"Evelyn Pabón" <epabon@coqui.n et> wrote in message
news:FPbGc.5979 $PO3.3529@fe39. usenetserver.co m...[color=blue]
> 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
>
>
>[/color]

[Chris Belcher]

Re: Help - Close Date and Effective Date

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:[color=blue]
> 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
>
>
>[/color]