I’ve created a Recurring Client Database. The client shows up weekly in the view based upon the day assigned using the WEEKDAY expression. If I have a client that isn’t weekly and is every other week is there a way to add this to my expression. I’ve been looking at the WEEKNUM expression, but I was wondering would an expression be possible using whether it was an even or odd WEEKNUM? Then I could assign the client odd or even based upon what week they are assigned?
User | Count |
---|---|
43 | |
30 | |
27 | |
14 | |
14 |