Help

Re: Return Day of the Week from Date Field

Solved
Jump to Solution
501 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Cody_Winchester
6 - Interface Innovator
6 - Interface Innovator

Hello,

I was curious if it’s possible for a formula to return the Day of the Week from Date Field? So, if my Date field reads, “9/27/2022,” is it possible for a formula to understand that this date is, “Tuesday?”

Thanks.

1 Solution

Accepted Solutions

You can also use


DATETIME_FORMAT({date}, 'dddd')

See Solution in Thread

4 Replies 4

Edit: Sorry, skip this post and just use kuovonne’s solution below; it’s much better

Hey Cody, yeah, I’d recommend a combination of a WEEKDAY() and a SWITCH()

Screenshot 2022-07-14 at 5.32.50 PM

You can find the set up here

You can also use


DATETIME_FORMAT({date}, 'dddd')

What! I didn’t know this was a thing; this is much simpler and I’m definitely using this in the future instead