Extracting the “day of the week” from the date

The date plugins are buggy. I don’t recommend using them.

You can get the Weekday name from a date without using any plugins as follows:

  • Create a lookup column that lists the days of the week, beginning from Sunday. This column can be anywhere, but I usually have it in a dedicated “Lookup” table

Screen Shot 2022-02-04 at 10.04.02 AM

  • Use a Math column to get the Weekday index number of the date in question: Weekday(Date)-1
  • Use a Single Value column to take the above index “from start” of your weekday lookup column.

Screen Shot 2022-02-04 at 10.06.32 AM