Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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

Dina
9 - Comet

Done

mdm
8 - Asteroid
Spoiler
mdm_0-1679731786629.png

 

 

This solution can handle any fiscal year end. You may define which month as the fiscal year end. The default month is defined in the Text Input tool.

Desmond
8 - Asteroid

My solution

MilindG
12 - Quasar
Spoiler
MilindG_0-1680031372827.png

 

lyon_abido
8 - Asteroid

Cool challenge!

 

Spoiler
Screenshot (168).png
karlhansen
9 - Comet
Spoiler
solution_359.jpg
JS1989
8 - Asteroid

Solution

dYoast
11 - Bolide

One overly complicated formula later...

Spoiler
dYoast_0-1680286237499.png

 

dYoast_1-1680286258515.png

 

Reesetrain2
9 - Comet

All,

I used a Text input and some code that I found in the community for my solution!

Spoiler
Capture.PNG

brianfia
8 - Asteroid
Spoiler
c_359_Manipulate_Dates_brianfia.PNG