Hi, Can I return the corresponding day of the...

(Tony Duggan) #1

Hi, Can I return the corresponding day of the week from a date in another column?

Thanks

(VICTOR VERA) #2

@Tony_DugganYes this can be done,

You can try an IFs expression like this where you want the value to returne:

IFS( WEEKDAY([DATE COLUMN])=1,SUNDAY, WEEKDAY([DATE COLUMN])=2,MONDAY, WEEKDAY([DATE COLUMN])=3,TUESDAY, WEEKDAY([DATE COLUMN])=4,WEDNESDAY, WEEKDAY([DATE COLUMN])=5,THURSDAY, WEEKDAY([DATE COLUMN])=6,FRIDAY, WEEKDAY([DATE COLUMN])=7,SATURDAY)

(Steven Coile) #3

switch(weekday([DATE COLUMN]),

1, “SUNDAY”,

2, "MONDAY,

3, "TUESDAY,

4, "WEDNESDAY,

5, "THURSDAY,

6, "FRIDAY,

7, "SATURDAY,

“” )

(Tony Duggan) #4

Many Thanks Victor :slight_smile:

(VICTOR VERA) #5

@Tony_Duggan +Steve Coile

Im pretty sure Coile’s expresion is more efective

(Tony Duggan) #6

thanks Steve

(Tony Duggan) #7

@VICTOR_VERA

cheers Victor