Help with automation email

[Jared12345]

Hi Community

Im trying to run an automation to send an email when there are no records entered for the day. 

So I created a slice called TodaysRecords where the Date column is equal to Today.

I've then created a scheduled automation.

I've scheduled it to run at 3pm and only if 

and (ISBLANK (TodaysRecords [TR_ID]), OR (TODAY()<>1, TODAY()<>7))

This is not running at all when I use the  Monitor function. 

What else can I try?

[dbaum]

---

@Jared12345 wrote:

This is not running at all when I use the  Monitor function. 

---

To be clear: Automation runs appear in the Automation Monitor only if their event, including any condition, triggers.

The TODAY function returns a date, such as 1/23/2023, not a number like 1 or 7.  Potentially, the problem in your expression is simply one of data types. Regardless, if you test an expression comparing TODAY to an integer from 1-7, you'll see that it returns false in every case:

Perhaps you intend to exclude Sundays and Saturdays, in which case you likely should use instead the WEEKDAY function. If that's your goal, then you also wouldn't use OR. Here's a new draft to modify and experiment with.

AND(
    ISBLANK(
        TodaysRecords[TR_ID]
    ),
    WEEKDAY(TODAY()) <> 1,
    WEEKAY(TODAY()) <> 7
)