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