Sign in to Community
Sign in to view all badges
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.?
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', ...))))