Could you elaborate? You can do a search with multiple criterias or even perform a constrain. You can create a calc. There are many possible solutions but what you want is not clear.
Sure. So, I want to constrain the values of a certain field to a range of dates. But, this range of dates will differ, depending upon the value of another field (Group_ID). So, if a contact is a member of Group "1A" in the Group_ID field, for example, users would only be able to enter a certain range of dates for the field "Assessment_1_StartDate." If a contact is a member of group "1B," however, users would have to enter a different range of dates for that field.
Does that make sense?
Under manage databases, click on the options for your date field. Go the the validation tab and validate by calculation.
You can use a Case () statement to deinfe your parameters.
What function do I use?
I already told you that you can use Case (). I dont know your situation but you can use something like:
Case ( IsEmpty ( group ); 1;
group ="1A"; YourDate >= Date ( 1;1;Year ( Get (CurrentDate) ) AND YourDate <= Date ( 12;31; Year ( Get (CurrentDate) );
group ="1B"; YourDate >= Date ( 1;1;Year ( Get (CurrentDate) ) AND YourDate <= Date ( 4;1; Year ( Get (CurrentDate) )
I would do a little more research on some of the functions.
One would hope that the ranges are recorded somewhere, preferably in the group record - so you can validate the field as:
Group::StartDate ≤ Self and Self ≤ Group::EndDate