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
Return Day of the Week from Date Field
+12Best answer by kuovonne
You can also use
DATETIME_FORMAT({date}, 'dddd')
+31Edit: 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
+29You 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
+12You can also use
DATETIME_FORMAT({date}, 'dddd')
Glorious! Thanks so much!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.