Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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 #367: Manipulating Dates – End of the Month

sparekh1
7 - Meteor
‎04-17-2023 11:29 PM

My Solution to Challenge #367:

 

Spoiler
sparekh1_0-1681799169717.png

 

challenge_367_start_file.yxzp
Reply
0 Likes
JereJussila
8 - Asteroid
‎04-17-2023 11:45 PM
Spoiler
JereJussila_2-1681800248529.png

 

lastofmonth parameter came in handy! 

challenge_367_solution_JJ.yxzp
Reply
0 Likes
CeliaC_Silje
8 - Asteroid
‎04-18-2023 12:00 AM
Spoiler
CeliaC_Silje_0-1681801164896.png

Learnt new thing today 😉

challenge_367_start_file.yxzp
Reply
0 Likes
DataCruncher2
7 - Meteor
‎04-18-2023 12:31 AM

Great Challenge.

Reply
0 Likes
DataCruncher3
7 - Meteor
‎04-18-2023 12:33 AM

Fun challenge!

Reply
0 Likes
lseiler
6 - Meteoroid
‎04-18-2023 01:54 AM

Here is my solution:

Spoiler
lseiler_0-1681808055774.png

 

challenge_367_start_file.yxmd
Reply
0 Likes
Christina_H
14 - Magnetar
‎04-18-2023 02:15 AM

Nice one for practicing date functions!

Spoiler
DateTimeFormat(DateTimeTrim(DateTimeParse([Date],"%m/%d/%y"),"lastofmonth"),"%m/%d/%y")
challenge_367_CH.yxmd
Reply
martinding
13 - Pulsar
‎04-18-2023 03:23 AM
Spoiler

martinding_0-1681813316920.png

 

challenge_367_start_file.yxzp
Reply
0 Likes
Sebastian_Chaieb2
11 - Bolide
11 - Bolide
‎04-18-2023 05:00 AM

Here is my solution

Spoiler
Sebastian_Chaieb2_0-1681819216005.png

 

challenge_367_Solution_SC.yxzp
Reply
0 Likes
JayAllcock
6 - Meteoroid
‎04-18-2023 05:47 AM

Fun little challenge.
May have taken some extra steps but looking forward to seeing the various approaches 🙂

challenge_367_start_file (Solution).yxmd
Reply
0 Likes
Live Weekly Challenge