Challenge #237: Wareki

[AYXAcademy]

A solution to last week's challenge can be found here. 

The Wareki is a Japanese date format which includes an extra character to signify the era. The eras indicate the emperor at the time and they impact the year only. For example, H04/01/31 represents the 4th year of Heisei era, but the 01/31 is in fact January 31st of that year.

Modern Japan, which is considered the period beginning in 1868, is currently in its 5th era. This week's challenge is to create a macro that converts Wareki dates into Alteryx Datetime or vice versa. The macro should include a configuration option for Wareki to Date or Date to Wareki.

[johnemery]

This was a really enjoyable challenge!

Spoiler

Watch my solution video here:

Spoiler

[Aaron_Harter]

Spoiler

[dsmdavid]

Went with a calendar table

Spoiler

[JennyMartin]

Spoiler

Great challenge for practising standard macros. Video solution here: https://www.youtube.com/watch?v=q27zJiC_n2A&list=PL18SpOXDj-KMUD4YwWC5vZaUsIa7drxNZ&index=41

[Blake]

That was a fun and interesting macro challenge. 

Spoiler

Edit 14:40 on 2020-10-12 to add video walkthrough

Spoiler

[RolandSchubert]

Spoiler

Nice challenge. 

[patrick_digan]

Spoiler

[OllieClarke]

Here's my solution to this week's challenge:

Spoiler

WorkflowMacroMacro Interface

[Jonathan-Sherman]

Challenge 237 is done!

Interface:

Spoiler

Macro:

Spoiler