Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThe trickiest part of this one was figuring out what I was supposed to do since the DateTime tool handles this situation without an issue. I'm guessing that tool wasn't around when this challenge was created so keeping in the spirit of the challenge, I had to decide how much of the conversion to do in a formula. Here's what I came up with
A similar solution to many other solutions out there. I this is slightly easy as compared to Macro problems.
The solving thrill continues!!!!!!!!!!!!!!!!
Regards,
Yugandhar Muley (Yug)
Alteryx ACE | Alteryx For Good Evangelist | Alteryx Addict
My first thought was that you didn't need a macro, just a datetimeparse formula but I didn't want to skimp on the requirement of building a macro so I also have that solution included too!