Week Day, Saturday or Sunday

Next-Gen
1

I’m using the script as below in a formula field to determine if a date falls on a week day, a Saturday or Sunday.

({Day}>1 & {Day}<7)? 1 : {Day}=7? 2 : 3

Doesn’t work and I don’t know why…

Any help much appreciated.

2

Hi @houwtama

Try This:

({Day}>1 & {Day}<7)? 1 : {Day}==7? 2 : 3

In Knack if you are equating 2 things you need a ==

Craig

1 Like
3

Thanks a million @CSWinnall !!! :grinning_face: :folded_hands:

1 Like