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

JSchiele
7 - Meteor
‎04-21-2023 05:44 AM

Done

challenge_367_done_JS.yxmd
Reply
0 Likes
mg46
8 - Asteroid
‎04-21-2023 09:41 AM

 

Spoiler
mguarniere_0-1682095261099.png

 

challenge_367_Michelle_G.yxzp
Reply
subhajit843
8 - Asteroid
‎04-21-2023 01:43 PM

Completed

challenge_367_start_file.yxmd
Reply
0 Likes
Yogesh1795
8 - Asteroid
‎04-22-2023 01:03 AM

learnt datetimetrim "lastofmonth"

challenge_367_start_file.yxmd
Reply
lanes1
8 - Asteroid
‎04-22-2023 04:50 PM
Spoiler
lanes1_0-1682207215994.pnglanes1_1-1682207290423.png

 

 

Love when the formula tool can do all the work!

challenge_367_solution.yxmd
Reply
0 Likes
RobertOdera
13 - Pulsar
‎04-23-2023 07:46 AM

Here is my solution - cheers.

Spoiler
RobertOdera_0-1682261117076.png

 

challenge_367.yxzp
Reply
0 Likes
MatthieuPons
7 - Meteor
‎04-24-2023 02:13 AM

 

Spoiler

MatthieuPons_0-1682327497866.png

 

Fun to do in one formula, could be quicker with

Spoiler
DateTimeTrim(Date, "LastOfmonth"....

Thanks for the tips in the previous solutions !

challenge_367_solution.yxmd
Reply
0 Likes
JS1989
8 - Asteroid
‎04-24-2023 06:33 AM

Solution

Solution_challenge_367_start_file.yxmd
Reply
0 Likes
Colintermeer
8 - Asteroid
‎04-24-2023 07:17 AM

answer

challenge_367.yxmd
Reply
0 Likes
lucascs
8 - Asteroid
‎04-24-2023 07:29 AM

sometimes lazy, I guess...

Spoiler
lucascs_0-1682346552527.png

 

challenge_367_start_file_solved.yxzp
Reply
0 Likes
Live Weekly Challenge