Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jul 13, 2022 05:39 PM
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.
Solved! Go to Solution.
Jul 14, 2022 03:29 AM
Jul 14, 2022 02:33 AM
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
Jul 14, 2022 03:29 AM
You can also use
DATETIME_FORMAT({date}, 'dddd')
Jul 14, 2022 03:50 AM
What! I didn’t know this was a thing; this is much simpler and I’m definitely using this in the future instead
Jul 14, 2022 10:11 AM
Glorious! Thanks so much!
Jul 25, 2023 02:28 PM
Hi how can i show day of next week ?