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

AndreaM
8 - Asteroid

Here is my solution

JasonW
6 - Meteoroid

 

Spoiler
JasonWhite_2-1682355856417.png

 

 

 

 

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

Reesetrain2
9 - Comet
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!
Capture.PNG

NathalieHP
8 - Asteroid

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

Spoiler
NathalieHP_0-1682417233345.png

 

CammyPhillips
8 - Asteroid
Spoiler
CammyPhillips_0-1682417200364.png

 

jcalteryx
Alteryx
Alteryx

My solution

Spoiler
jcalteryx_0-1682419743263.png

 

Mok3bat
7 - Meteor

Here's my Solution

DavidCoulson
7 - Meteor

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

karlhansen
9 - Comet
Spoiler
solution_367.jpg

BSilverblatt
8 - Asteroid

Thanks for the challenge! Here's my solution: