Looking for error message help
I have a project table that has a Start Date and a Complete Date. When the user enters a project I want to make sure that the Start Date is before the Completion Date, If they enter a value that i...
Forum Discussion
Thanks Don! That's what I needed. No I'm not Dr. Who but wouldn't that be fun!
------Original Message------
Delynn,
Do you allow the Users to Grid Edit these dates? If the answer is no, meaning that they are always working inside of a form, you can build a form rule that will Abort the Save and Display a message when the [Completion Date] is < [Start Date].
If you do let them Grid Edit or Import Values to the fields then this is a more complicated problem. Reach out if you need to discuss an intricate business process.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
- Go to table settings
- Go to Advanced settings
- At the bottom there is a part called 'Build custom data rules for this table'
- Put in the following formula
If([Complete Date]<[Start Date],"Complete Date cannot occur before Start Date! Exterminate!! Exterminate!!")
- Check the box Turn custom data rules on?
- Save
------------------------------
jason johnson
------------------------------
- Jason,
Davros loves the last part.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------- Obviously we are having way to mich fun with this one... lol
------Original Message------
Jason,
Davros loves the last part.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
