Hi, is it possible to restrict data input values on table level?
I have two fields in my table, say: Date1 and Date2. I wanted to make the data entries where Date2 is always greater than Date1. Would this be possible.
Thanks in advance
Yes. This is possible. The only pre-requisites are:
1.) You must have an auto-number field in your table.
2.) Date1 and Date2 should have a DataType of Date/Time.
Once these requirements are met, you just need to add a formula field to your table.
The syntax would be as follows:
[@field:Date2] < [@field:Date1]
THEN CAST( 'a' + 1 as INT)
Works for me.
Hope this helps.