Help

Return Day of the Week from Date Field

Topic Labels: Dates & Timezones
Solved
Jump to Solution
6149 5
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
kuovonne
18 - Pluto
18 - Pluto

You can also use


DATETIME_FORMAT({date}, 'dddd')

See Solution in Thread

5 Replies 5

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

kuovonne
18 - Pluto
18 - Pluto

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

Glorious! Thanks so much!

Hi   how can i show day of next week ?   

WeChat0cb98e24765c211baa2164d8c07b9815.jpg