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: