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
Meteoro

My Solution to Challenge #367:

 

Saqueador
sparekh1_0-1681799169717.png

 

JereJussila
Asteroide
Saqueador
JereJussila_2-1681800248529.png

 

lastofmonth parameter came in handy! 

CeliaC_Silje
Asteroide
Saqueador
CeliaC_Silje_0-1681801164896.png

Learnt new thing today 😉

DataCruncher2
Meteoro

Great Challenge.

DataCruncher3
Meteoro

Fun challenge!

lseiler
Meteoroide

Here is my solution:

Saqueador
lseiler_0-1681808055774.png

 

Christina_H
Magnetar

Nice one for practicing date functions!

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

martinding_0-1681813316920.png

 

Sebastian_Chaieb2
8 - Asteroid
8 - Asteroid

Here is my solution

Saqueador
Sebastian_Chaieb2_0-1681819216005.png

 

JayAllcock
Meteoroide

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