Derive Day of Week from Date

[rntrp]

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

[Jonathon_wodnicki · Accepted solution]

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

[rntrp]

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!

[DavidKangni]

You can use formatDate option % A for short day name in a javascript https://docs.adobe.com/content/help/en/campaign-classic/technicalresources/api/f-formatDate.html?hl=...

[rntrp]

Update. I used the Weekday function to derive the day of week from date. FYI - week starts at Day 0. So 0 = Monday and so on. Then converted this to String. Then used iif to say if 0 then Monday, else if 1 Tuesday and so on. Thanks.