Derive Day of Week from Date

Accepted Solutions (1)

Accepted Solutions (1)

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)