community Alteryx IO Mission Control
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
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