Syntax for Custom Column to Show Current WeekDay Number

[Justair07]

Hi,

Can someone please tell me how I can make a custom column in the Query Editor? Here is what I tried with error that WEEKDAY not recognized.

=WEEKDAY(TODAY(),2)

Thank you,

- Justin

[arvindsingh802]

Hello Justair07,

Use WeekDay =Date.DayOfWeek(DateTime.LocalNow())

[Justair07 · Accepted solution]

I got it. Date.DayOfWeek(DateTime.LocalNow()) Thank you