Set Variable as DayofWeek from Now()

(0) Share

Report

Posted on by buddhasbuddy

Good Day,

I want my Chatbot to check if the current date time is within a specific timeframe (ex. Tuesday between 11AM and 12PM). I can't figure out how to get the DayofWeek from Now() in the formula. DayofWeek function doesn't seem to exist nor does Weekday. I am looking for something like...

If(Weekday(Now())=3,true,false) <==Check if it is Tuesday

If(And(Weekday(Now())=3,Hour(Now())>=11,Hour(Now())<12), true, false) <==Check if the current Date Time is within Tuesday between 11 and 12)

All responses (2)

Answers (1)

Verified answer

dian74 63 Most Valuable Professional on at

Like (0)

Report

Re: Set Variable as DayofWeek from Now()

I don't believe this is supported today. https://powerusers.microsoft.com/t5/General/PVA-Unified-Canvas-Power-Fx-Support/m-p/1919018#M4686
buddhasbuddy 15 on at

Like (0)

Report

Re: Set Variable as DayofWeek from Now()

I realise I could use Power Automate to do this but can't it be done in PVA?