Auto Enter Current Date into Multiple Fields depending on check box selection.
Ok this should be fairly simple but I can't seem to find the answer.
I have a check box set with four values. Each value has its own date field next to it. Whenever a value is checked I want it to auto-enter the current date into the corresponding date field.
I tried using an If function in each of the date fields like this:
If (Field1 = "Value1" ; Get(CurrentDate) ; "")
Which works fantastically when you select one check box but as soon as you check another the date disappears.
Any ideas how I could get this to work?