Creating a validation formula

[kinyee]

I have created a form with a date/time field called RequiredDate. I placed a
validation formula such that if [RequiredDate] = "", then a message is
displayed indicating that the field must contain a date. This works great,
however, even after the field contains a date, the validation message keeps
being displayed. Why???

 

[Ken Slovak - [MVP - Outlook]]

The Outlook value for a Null date is #1/1/4501#. Try testing for that and
see if it works.

 

[kinyee]

Thank you for that tip, this validation formula works now. However, I have a
similar, though different problem. I want to set the Subject line so that
users have to enter a date. Since I can't change the format of Subject from
Text to Date/Time, I created a new field called SubjectDate with a Date/Time
format and a validation formula such that if it's left blank, users will get
a message telling them they must enter a date. Whatever date is entered is
automatically formated to dd-mm-yy. This works great, except once the form
is sent, the Subject line comes out blank (no Subject).

I then decided to leave the Subject as a Text field, with the same
validation formula (must enter date). This time, the Subject line comes out
properly once the form is sent, but I want the date format to automatically
convert to dd-mm-yy.

Is there a way of either getting the Subject line to display if a field
other than Subject is used, or writing a validation formula that will convert
a date entered as text to dd-mm-yy format?

 

[Sue Mosher [MVP-Outlook]]

Did you set a formula for the Subject field so that it uses the value in SubjectDate?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

Thank you for that tip, this validation formula works now. However, I have a
similar, though different problem. I want to set the Subject line so that
users have to enter a date. Since I can't change the format of Subject from
Text to Date/Time, I created a new field called SubjectDate with a Date/Time
format and a validation formula such that if it's left blank, users will get
a message telling them they must enter a date. Whatever date is entered is
automatically formated to dd-mm-yy. This works great, except once the form
is sent, the Subject line comes out blank (no Subject).

I then decided to leave the Subject as a Text field, with the same
validation formula (must enter date). This time, the Subject line comes out
properly once the form is sent, but I want the date format to automatically
convert to dd-mm-yy.

Is there a way of either getting the Subject line to display if a field
other than Subject is used, or writing a validation formula that will convert
a date entered as text to dd-mm-yy format?

I have created a form with a date/time field called RequiredDate. I placed a
validation formula such that if [RequiredDate] = "", then a message is
displayed indicating that the field must contain a date. This works great,
however, even after the field contains a date, the validation message keeps
being displayed. Why???