alteryx Community

# 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.

## Challenge #367: Manipulating Dates – End of the Month

8 - Asteroid

Here is my solution

6 - Meteoroid

Spoiler

I thought I was going to need two formulas, but then remembered the lastofmonth argument for DateTimeTrim().

9 - Comet

All,

Spoiler
I used two methods, with the date time add and the datetime trim, last of the month function.
-Shout out to Nicole Johnson for that cool function!

8 - Asteroid

My solution, taking in consideration that 2024 is a leap year:

Spoiler

8 - Asteroid
Spoiler

Alteryx

My solution

Spoiler

7 - Meteor

Here's my Solution

7 - Meteor

I feel others have more elegant solutions than what I came up with for this challenge.  Good work folks!

9 - Comet
Spoiler

8 - Asteroid

Thanks for the challenge! Here's my solution: