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

alacoume
9 - Comet
‎04-18-2023 06:41 AM

A lot of people are fast!!

challenge_367_start_file.yxmd
Reply
0 Likes
ferg_smith
8 - Asteroid
‎04-18-2023 07:32 AM
Spoiler
ferg_smith_0-1681828310732.png

 

367 completed.yxzp
Reply
0 Likes
NMangera
11 - Bolide
‎04-18-2023 09:25 AM
Spoiler
NMangera_0-1681835010676.png

 

TA:

1. argument: 'lastofmonth' to the DateTimeTrim function

challenge_367_NM.yxmd
Reply
0 Likes
LHolmes
9 - Comet
‎04-18-2023 10:11 AM

Better date than never.

 

Spoiler
367 - Solution.PNG
challenge_367_solution_lmh.yxzp
Reply
0 Likes
SGolnik
11 - Bolide
11 - Bolide
‎04-18-2023 10:23 AM

This was my first time using Designer Cloud (Trifecta) to do a weekly challenge. I ended up doing it in 10 steps, but think it might be able to be done in less. 

Spoiler
SGolnik_1-1681838571732.png

 

 

flow_Challenge_367.zip
Reply
0 Likes
KevinWim
6 - Meteoroid
‎04-18-2023 10:30 AM
Spoiler
SPOILERSPOILER

 

 

 

 

 

 

 

 

 

My solution!

Challenge 367-Manipulating Dates.yxmd
Reply
0 Likes
Coakles
7 - Meteor
‎04-18-2023 10:57 AM
Spoiler
Coakles_0-1681840607534.png

 

challenge_367_Date MC.yxmd
Reply
0 Likes
dougbaron
8 - Asteroid
‎04-18-2023 11:27 AM

solved in 2 tools

Spoiler
dougbaron_0-1681842398444.png

 

challenge_367_final_file.yxzp
Reply
0 Likes
Justin_B
8 - Asteroid
‎04-18-2023 11:41 AM

My solution:

Spoiler
Justin_B_0-1681843272074.png

 

challenge_367_solution_file_jb.yxzp
Reply
0 Likes
TonyAndriani
9 - Comet
‎04-18-2023 12:36 PM

My solution. Just for laughs I did it in one expression in a Formula.  And then I saw @DataNath's solution. You learn something new every day...

Spoiler
TonyAndriani_0-1681846321185.pngTonyAndriani_3-1681846389900.png

 

  

challenge_367_TonyA.yxmd
Reply
Live Weekly Challenge