"or" syntax

[lsmall]

I am trying to create a field that will create a flag for a date field when the value is saturday or sunday. Here is my calculation where the date field is "service date". I have also tried this using DayofWeek with 1 or 7 for the weekend days.

If (DayName ( Service Date ) = "Sunday" or "Saturday" ; "Y" ; "-")

It does successfully flag the first day specified, but not the second, so I am probably not using "or" correctly. I have tried various permutations, but without success

I would appreciate some help with this.

Thanks

[Ender]

Try:

If ( DayName ( Service Date ) = "Sunday" or DayName ( Service Date ) = "Saturday" ; "Y" ; "-" )

[lsmall]

Excellent thanks. I guess I missed that permutation.

Thanks a lot!