Sometimes you want to get the Day of Week names such as Sunday or Monday from Date data.

For example, here is a flight data. It has a Date column for flight dates (FL_DATE).

If you want to get the Day of Week names from the flight dates. you can click the column header menu of “FL_DATE”, choose “Extract” and “Day of Week Name (e.g. Mon)”.

Then, it opens up the dialog. You can just click “Run” button.

It will create a column “FL_DATE_wday” with the Day of Week Names.


If you use a chart, you don’t even have to create a new column like above. For example, if you want to show the bars by Day of Week Names, you can assign “FL_DATE” to X Axis, and choose “Day of Week Names” from the function list.