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

AaronSmatta
8 - Asteroid

Solution

OllieClarke
15 - Aurora
15 - Aurora

It'd be nice if there were a Quarter specifier...

Spoiler
OllieClarke_0-1680785702292.png
Right([Date],4)
+
'Q'
+
tostring(Floor((Tonumber(Left([Date],findstring([Date],'/')))-1)/3)+1)

 

Shifty
12 - Quasar

Dating can be tough sometimes. 😁

 

Spoiler
Shifty_0-1681223096666.png

 

JosephSerpis
17 - Castor
17 - Castor

Challenge Completed

 

Spoiler
Weekly_Challenge_359.JPG

 

 

 

Mythili-Subramanian
6 - Meteoroid

Challenge # 359: Manipulating Dates - Solution

Milanz
8 - Asteroid

my solution ;-)

 

Spoiler
Milanz_0-1681719411118.png

 

Caxxx
6 - Meteoroid

 

Spoiler
Caxxx_0-1681790122143.png

 

hharris0411
8 - Asteroid
Spoiler
hharris0411_0-1681915113974.png

 

CasperBuenting
7 - Meteor
Spoiler
CasperBuenting_0-1681976491542.png

 

 Solution

Eugenialg
7 - Meteor

done