Derive Day of Week from Date

4 replies
7172 views
Translate

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.?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Jonathon_wodnickiAccepted solution

New Participant

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

Jonathon_wodnickiAccepted solution

New Participant

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

Translate

R

rntrpAuthor

Level 3

Thanks. I was going down the same path - I was going to use Case statements. Was wondering if there was any pre-built function. Will try both, thanks!

Translate

Sign up

Login with SSO

Login to the community

Login with SSO