Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAPretty straight forward here. Looking back, I could have made this slightly more efficient in terms of how many tools to use.
Just right after I have been fiddling with Python, the passing dates seemed to be easy.
Well at least I thought so until once more I saw @Joe_Mako' sweet solution.
Anyway, here is mine
My formula look like this:
DateTimeParse(IIF(Left([date], 1)=="1","20"+Right([date], 6),"19"+Right([date], 6)),"%Y%m%d")
Still Climbing
/Thomas