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

sparekh1
7 - Meteor

My Solution to Challenge #367:

 

Spoiler
sparekh1_0-1681799169717.png

 

JereJussila
8 - Asteroid
Spoiler
JereJussila_2-1681800248529.png

 

lastofmonth parameter came in handy! 

CeliaC_Silje
8 - Asteroid
Spoiler
CeliaC_Silje_0-1681801164896.png

Learnt new thing today 😉

DataCruncher2
7 - Meteor

Great Challenge.

DataCruncher3
7 - Meteor

Fun challenge!

lseiler
6 - Meteoroid

Here is my solution:

Spoiler
lseiler_0-1681808055774.png

 

Christina_H
14 - Magnetar

Nice one for practicing date functions!

Spoiler
DateTimeFormat(DateTimeTrim(DateTimeParse([Date],"%m/%d/%y"),"lastofmonth"),"%m/%d/%y")
martinding
13 - Pulsar
Spoiler

martinding_0-1681813316920.png

 

Sebastian_Chaieb2
8 - Asteroid
8 - Asteroid

Here is my solution

Spoiler
Sebastian_Chaieb2_0-1681819216005.png

 

JayAllcock
6 - Meteoroid

Fun little challenge.
May have taken some extra steps but looking forward to seeing the various approaches 🙂