Formula evaluating 2 fields

G

Guest

Hi,

I have a scenario where when a date is entered into a date field the user
must also enter the version changed. Keeping the mind frame that False is
bad I have created the following formula.

([Development Completed]<>#1/1/4501#) OR ([Version Changed]<>"")

This however is not causing any validation. Any assistance would be
appreciated.

Thank-you.
 
S

Sue Mosher [MVP-Outlook]

How about this :

([Development Completed] = "None") OR ([Version Changed]<>"")


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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top