Help

Changing Date Field to Show Day of Week

Solved
Jump to Solution
9110 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Tobin_Perry
6 - Interface Innovator
6 - Interface Innovator

Is it possible to have the date field show a day of the week instead of a date?

1 Solution

Accepted Solutions

Well, it’s a little uglier to look at, but adjust the formula to this:

WEEKDAY({Date Field}) & " - " &
DATETIME_FORMAT({Date Field}, 'dddd')

That will prefix the day as text with the number of that day in the week:
image

That will sort the days in their appropriate week order when sorting by that field.

See Solution in Thread

4 Replies 4

It’s not possible to have a Date field do that, but it’s possible to have a Formula field process a date in a Date field and output the day of the week for that date.

DATETIME_FORMAT({Date Field}, 'dddd')

Optionally, you can have it abbreviated by using a different format specifier:
image

5f73751092c6afb3485d0dfe997b3809227f5002.png

Supported format specifiers for DATETIME_FORMAT

The DATETIME_FORMAT function will allow you to reformat the data from the date-type field into a string of your specifications. This is written in the form "DATETIME_FORMAT(Datetime, 'format s...

Tobin_Perry
6 - Interface Innovator
6 - Interface Innovator

That’s very helpful! Now is it possible when those items are grouped to order them in the correct order? Right now it orders them alphabetically … Friday, Tuesday, Thursday, Wednesday. Alphabetical seems like the only option.

Well, it’s a little uglier to look at, but adjust the formula to this:

WEEKDAY({Date Field}) & " - " &
DATETIME_FORMAT({Date Field}, 'dddd')

That will prefix the day as text with the number of that day in the week:
image

That will sort the days in their appropriate week order when sorting by that field.

Tobin_Perry
6 - Interface Innovator
6 - Interface Innovator

Perfect, thanks! Just what I needed…