ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #359: Manipulating Dates

NathalieHP
8 - Asteroid
‎02-21-2023 06:02 AM

My solution:

 

Spoiler
NathalieHP_0-1676988082911.png

 

challenge_359_solution.yxmd
Reply
0 Likes
Luke_C
17 - Castor
17 - Castor
‎02-21-2023 06:13 AM

Don't have the quarter formula yet but still a 1-tooler:

 

Spoiler
Luke_C_0-1676988786959.png

 

challenge_359_solution.yxmd
Reply
0 Likes
ARussell34
8 - Asteroid
‎02-21-2023 06:33 AM

Here is my solution!

AR_challenge359_sol.yxmd
Reply
0 Likes
anthonyw
8 - Asteroid
‎02-21-2023 07:13 AM

Challenge Completed!

challenge_359_Complete.yxmd
Reply
0 Likes
lanclot23
7 - Meteor
‎02-21-2023 07:49 AM
Spoiler
359.png
359 - lanclot23.yxzp
Reply
0 Likes
muradmusleh
6 - Meteoroid
‎02-21-2023 08:08 AM

 Challenge #359: Manipulating Dates
I used ParsetoDate to convert String to Date, after that I used Formula with DateTimeFormat

challenge_359_solution.yxmd
Reply
0 Likes
alacoume
9 - Comet
‎02-21-2023 08:26 AM

My solution:

challenge_359.yxmd
Reply
0 Likes
CammyPhillips
8 - Asteroid
‎02-21-2023 08:35 AM
Spoiler
CammyPhillips_0-1676997327086.png

 

Reply
0 Likes
olga_strubbe
11 - Bolide
‎02-21-2023 09:19 AM
Spoiler
olga_strubbe_0-1676999909759.png

 

Challenge 359_Manipulating Dates.yxmd
Reply
0 Likes
pmyers
Alteryx
Alteryx
‎02-21-2023 01:01 PM

One tool solution

 

Spoiler
pmyers_0-1677013242395.png

Formula:
IF Left([Date], 2)="1/" || Left([Date], 2)="2/" || Left([Date], 2)="3/" THEN Right([Date], 4) + "Q1"

ELSEIF Left([Date], 2)="4/" || Left([Date], 2)="5/" || Left([Date], 2)="6/" THEN Right([Date], 4) + "Q2"

ELSEIF Left([Date], 2)="7/" || Left([Date], 2)="8/" || Left([Date], 2)="9/" THEN Right([Date], 4) + "Q3"

ELSEIF Left([Date], 2)="10" || Left([Date], 2)="11" || Left([Date], 2)="12" THEN Right([Date], 4) + "Q4"

ELSE "" ENDIF

Reply
0 Likes