Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Return Day of the Week from Date Field

Topic Labels: Dates & Timezones
Solved
Jump to Solution
7297 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