Challenge #237: Wareki

[JasonHu]

Spoiler

Here is my submission, nice to learn the new tool that I never use before.

[johnzrgu75]

Spoiler

[paultno]

My solution.  

[danilang]

Fun one

Spoiler

Dan

[MUHAMMED_NABEEL_P]

Good challenge to explore more on macros..

[AlexC2]

great challenge!

got slightly different answers for the Date to Wareki, but probably due to assumptions on whether to round up/down date differences

also did a slightly different approach to output the type of conversion in post report, instead of allowing user input

Spoiler

[Erin]

I designed this so that Field 1 is converted from a string into both a date and Wareki format. Curious to see how to set it up so the user selects the desired output vs including both in the output. 

[jjrbondoc]

Spoiler

[MichaelPilotFreight]

Check out my solution!

[RWvanLeeuwen]

Nice to finally have some time to reboot my muscle memory on macros

Spoiler

Workflow overall:

Spoiler

what do we define as the first year? I focussed on a datediff approach in years from the start date of the period... This might be why my result is different from what's seemingly required as a solution

Macro details:

Spoiler