Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

rntrp
Community profile rntrp Level 1
Job title here
Location here
2 BADGES
Level 1

Level 1

Learn more
Joined the community 06-04-2020 1:23:57 PM
Offline
Top badges earned by rntrp
Customize the badges you want to showcase on your profile
Re: Derive Day of Week from Date
Avatar
Give Back
Level 1
rntrp
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
View profile
rntrp
- Adobe Campaign Classic
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.

Views

5.2K

Likes

0

Replies

0
Re: Derive Day of Week from Date
Avatar
Give Back
Level 1
rntrp
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
View profile
rntrp
- Adobe Campaign Classic
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!

Views

5.2K

Likes

0

Replies

0
Derive Day of Week from Date
Avatar
Give Back
Level 1
rntrp
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
View profile
rntrp
- Adobe Campaign Classic
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.?

Views

5.2K

Likes

0

Replies

4