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 #359: Manipulating Dates

a-gonzalez
7 - Meteor
Spoiler
Screenshot 2024-06-14 121532.png
Prathameshmanakapure
8 - Asteroid

My Solution

Verakso
11 - Bolide

My solution

Spoiler
WorflowWorflowI used this formula:
DateTimeFormat(DateTimeParse([Date],"%m/%d/%Y"),"%YQ")+
ToString(CEIL(ToNumber(DateTimeFormat(DateTimeParse([Date],"%m/%d/%Y"),"%m"))/3))​

Br ()

Thomas

TobiasFitschen
8 - Asteroid
Spoiler
Challenge_359.png

lwolfie
11 - Bolide

I've used this sooooo many times.

mkeiffer
10 - Fireball
10 - Fireball

My solution!

Spoiler
Screenshot 2024-08-01 at 10.06.11 PM.png

Supriya2203
8 - Asteroid

My Solution

KodyKlein
7 - Meteor

Fun challenge. Thanks!

rebecca_petter
8 - Asteroid

Done

danbostrom
8 - Asteroid