Re: How to show complete date, weekday names

J_jvs · 06-08-2020 02:14 AM

Hi Team,
how can i show name of the day (monday, tuesday, …)?

br

Suvrutt_Gurjar

Edit Your post title mentions “How To show complete date” and in the post you have mentioned “weekday names” So I presume you wish to display entire date along with the weekday name.

If so, please try an expression something like

TEXT([Date Column Name],“DDD DD MMM YYYY”)

will display something like below

Fri 01 Jan 2016

The format
CONCATENATE(TEXT([Date Column Name ],“DDD”),"day ", [Date Column Name])
will display in something like below
Monday 02/01/2016

In general one can format the date in many ways using TEXT() expressions. Please refer to below help article

Aleksi

@Suvrutt_Gurjar How about when it’s a Wednesday… or should we call it Wedday

Suvrutt_Gurjar

@Aleksi ,

Oops ! Great catch !

Wedday will be very funny indeed

Even Saturday may become Satday !

Suvrutt_Gurjar

Minor change in above expression. Please make it something like

CONCATENATE(TEXT([Date Column Name],“DDDD”),", ", [Date Column Name])

The TEXT() expressions seem to be really powerful. The output of above expression will be something like below

Saturday, 01/02/2016

**Edit:**Minor typo edited.

J_jvs

ok, thks a lot , its running OK.
I used : “TEXT([Date],“DDDD”)”

br

Gowtham

Yes @J_jvs it can be done.
Use the function as WEEKDAY([YourDateColumn]) it will return the matching weekday number for the date value in your column.
As you want to display this number as the name of the weekday, you should construct an IFS expression with the WEEKDAY function like below

IFS( WEEKDAY(TODAY())=“1”,“Sunday”, WEEKDAY(TODAY())=“2”,“Monday”, WEEKDAY(TODAY())=“3”,“Tuesday”, WEEKDAY(TODAY())=“4”,“Wednesday”, WEEKDAY(TODAY())=“5”,“Thursday”, WEEKDAY(TODAY())=“6”,“Friday”, WEEKDAY(TODAY())=“7”,“Saturday” )

Replace WEEKDAY(TODAY()) with your WEEKDAY([Your Date Column]).