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 #237: Wareki

JP_SDAK
8 - Asteroid

This took a while to get the macro to work - good practice with Detours.

Spoiler
JP_SDAK_1-1611203851580.png
JP_SDAK_0-1611203813526.png

 

 

 

mhey01
7 - Meteor

Solved 🙂

 

Spoiler
237_results.png237_macro.PNG
mike_w
8 - Asteroid

I also added the option of providing your own Date or Wareki. It'll be added to the results, respectively.

Spoiler
mike_w_0-1611602292832.png

 

robert-headington
8 - Asteroid

Built the macro so it can take any field and convert it into the other date

apathetichell
18 - Pollux

Converting from Wareki to standard seemed to go much slower than converting from standard to Wareki - despite the overwrought nested IF/THEN/ELSEIFs for the date range comparison...

TraceyD
Alteryx Alumni (Retired)

An excellent challenge!  Here's my solution.

rcarog
8 - Asteroid

Solution attached.

MattBenj
9 - Comet

It's great to see the variety of solutions this week.

lewanark
8 - Asteroid
Spoiler
lewanark_0-1617201911604.png

 

nice challenge 🙂

mdsalmankhan89
8 - Asteroid

here is my solution  !