return current dayname from list

[_giles_]

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

[comment]

Try =

If ( not IsEmpty ( FilterValues ( DayName ( Get ( CurrentDate ) ) ; day ) ) ; "Current" )

This is assuming the 'day' field contains a return-separated list of day names.