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
メテオール

My Solution to Challenge #367:

 

スポイラ
sparekh1_0-1681799169717.png

 

JereJussila
アステロイド
スポイラ
JereJussila_2-1681800248529.png

 

lastofmonth parameter came in handy! 

CeliaC_Silje
アステロイド
スポイラ
CeliaC_Silje_0-1681801164896.png

Learnt new thing today 😉

DataCruncher2
メテオール

Great Challenge.

DataCruncher3
メテオール

Fun challenge!

lseiler
メテオロイド

Here is my solution:

スポイラ
lseiler_0-1681808055774.png

 

Christina_H
マグネター

Nice one for practicing date functions!

スポイラ
DateTimeFormat(DateTimeTrim(DateTimeParse([Date],"%m/%d/%y"),"lastofmonth"),"%m/%d/%y")
martinding
パルサー
スポイラ

martinding_0-1681813316920.png

 

Sebastian_Chaieb2
8 - Asteroid
8 - Asteroid

Here is my solution

スポイラ
Sebastian_Chaieb2_0-1681819216005.png

 

JayAllcock
メテオロイド

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