Hi. I only want to run an automated bot on a weekday, so not on Saturday or Sunday. I thought I had the correct expression but it doesn't run.
AND(COUNT(LIST(SOR Current Year NON Uplifted to Insight[Unique ID]))>0 , Day(Today())<>"6" , Day (Today())<>"0")
What have I got wrong?
AND(
WEEKDAY(TODAY()) > 1,
WEEKDAY(TODAY()) < 7
)
AND(
COUNT(LIST(SOR Current Year NON Uplifted to Insight[Unique ID])) > 0,
WEEKDAY(TODAY()) <> 6,
WEEKDAY(TODAY()) <> 0
)
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |