Derive Day of Week from Date

Avatar

Avatar

rntrp

Avatar

rntrp

rntrp

24-04-2020

I used the Day function on a date field and it returns an integer. How do we convert this to the day of the week - Mon, Tue etc.?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

wodnicki

MVP

Avatar

wodnicki

MVP

wodnicki
MVP

24-04-2020

Hi,

 

In an xtk expression? You'd have to use a long chain of decode's or iif's. Assuming Day() counts from 1:

decode(Day(@date), 1, 'Sun', decode(Day(@date), 2, 'Mon', decode(Day(@date), 3, 'Tue', ...))))

 

Thanks,

-Jon

Answers (0)