Skip to main content

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.

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()

You can find the set up here

You can also use


DATETIME_FORMAT({date}, 'dddd')

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

You can also use


DATETIME_FORMAT({date}, 'dddd')

Glorious! Thanks so much!

You can also use


DATETIME_FORMAT({date}, 'dddd')

Hi   how can i show day of next week ?   

 

Terms & ConditionsAccessibility statement