Challenge #237: Wareki

[LukaszKarpinski]

Hi,

My solution below:

Spoiler

[Watermark]

Couple solutions: one with and one without macros

Spoiler

 

Spoiler

 

[peter_gb]

Very satisfying to do a macro challenge!

Spoiler

 

[MalluShroomer]

That was a good one. 

[MariusNikiforovas]

A nice challenge, could possibly simplify the solution but it does the job

Spoiler

[LiuZhang]

Spoiler

Not sure about why S and T era doesn't match, did both datetimediff(dt1, dt2, 'year') and datetimediff(dt1, dt2, 'day')/365 

[FrederikE]

Spoiler

[EW]

I don't use Alteryx macros every day, so it's very exciting when one comes together!  

Spoiler

[TonyAndriani]

Reposting under my new user ID.

[usmanghayoor]

Spoiler