The method I use to get the weekday from a date is as follows:
- Firstly, I create a column that contains the names of the days of the week (Sun, Mon, Tue, etc). This column can be in any table (I usually have it in a Lookup/Helper table)
- Then I use the following Math formula on my Date column:
Weekday(Date)-1
– This returns an integer between 0 and 6, representing the day number of the week, beginning with Sunday == 0 - I then use a Single Value column to fetch the Day name from my list of days, using
N
from start, whereN
is the result of the math column.
A simpler option is to use the Format Date plugin, however that plugin is known to give inconsistent results with Safari on IOS, so I don’t use it for that reason.