How to show Day of the week (Sunday, Monday, Tuesday...) from [Date] column

AppSheet AppSheet Q&A
1

Howdy!

How can I Show Day of the week (Sunday, Monday, Tuesday…) from a [Date] column?

I’m having trouble with this set up.

Virtual Column 1 [Day Number] uses =WEEKDAY([Date]) to find the number of Day of the week 1,2,3,4…

Virtual Column 2 I used SWITCH([Day Number], “Sunday”, “Monday”, “Tuesday”, “Wednesday”, “Thursday”, “Friday”, “Saturday”)

It likes the expression, but it seems to only return Saturday for everything.

Is there a better way to find the Day of the week like Sunday, Monday, Tuesday from a date…?

TYVM!

2

I don’t have experience with those functions, but I see the following different suggestion in the WEEKDAY() - AppSheet Help article. If this doesn’t work either, you should probably start by checking what’s being returned by your WEEKDAY function. Maybe your [Date] column isn’t actually a date or something.

INDEX(LIST("Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat"), WEEKDAY("1/1/2019"))
1 Like
3

You could also use TEXT() functions to show the day of the week based on date,

TEXT([Date], “DDDD”)

TEXT() - AppSheet Help

4 Likes
4

Thank you! But I used the perfect first Solution of TEXT([Date], “DDDD”) to
get “Sunday”, “Monday” … and also TEXT([Date], “DDD”) to get the
abbreviated “Sun”, “Mon”, “Tue” . It’s already in my app and working
perfectly. Using the short version in the App to save space, and the long
version in my Bot Emails where I have plenty of space & need more inclusive
information. TYVM!

1 Like
5

I responded to Mr. Suvrutt inside my email notification about his excellent Solution, I thought that it would automatically include my response here, looks like it did not, so I will copy/paste it now. His solution is working perfectly in my App & in my Bot Emails & now SMS messages.

Sweet, thank you very much!
I will use both versions of this in virtual Columns. =TEXT([Date],“DDD”) giving me short version “Tue”, “Wed” for use in the App and in Bot/SMS messages to save space.
And I’ll use =TEXT([Date],“DDDD”) so I can display the full “Sunday”, “Monday”… in my Bot Email templates where I have plenty of space. :+1:

Thank you!

4 Likes