August 20, 201213 yr Dear All, I have the following which works fine if the field "day" contains a single value like "Monday", but fails if it contains multiple values (like "Monday Wednesday Thursday"). Can you advise? If( day = DayName ( Get ( CurrentDate ) ); "Current" ; "" ) Many thanks
August 20, 201213 yr Try = If ( not IsEmpty ( FilterValues ( DayName ( Get ( CurrentDate ) ) ; day ) ) ; "Current" ) This is assuming the 'day' field contains a return-separated list of day names.
Create an account or sign in to comment