Setting a ending date

[Matilda]

I am new to writing formulas. I cannot figure out how to
write the string in a form document. I have a form that
I have set the date to change each day but I want to set
it so that it will not update past 8-1-04. Is there
anyone out there that can help me write the formula?
Your help will be greatly appreciated. Thanks, Matilda

 

[Matilda]

I can write the formula just as you have it below but
when I toggle off with Alt-9 it gives me 8-1-04. I want
it to give the current date on the form until 8-1-04, at
which time the date does not update and the following
statement appears "This form has expired". What effect
will this have when I protect the form document. Also,
if I share this document should I password protect so
they can not make any changes to the original document.
Thanks for all your help. Matilda

 

[Doug Robbins - Word MVP]

Hi Matilda,

Use the following field construction.

{ IF { DATE \@ YYYYMMDD } > 20040108 "This form has expired" { DATE \@
"M-D-YY" } }

You will need to update the fields the get it to display the correct result.
--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP