Forum Discussion
Solved
Syntax for Custom Column to Show Current WeekDay Number
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
- I got it. Date.DayOfWeek(DateTime.LocalNow()) Thank you
2 Replies
Hello Justair07,
Use WeekDay =Date.DayOfWeek(DateTime.LocalNow())
- I got it. Date.DayOfWeek(DateTime.LocalNow()) Thank you
