Date Time Converter

[AFerency]

Using a simple Date Time Converter for 1-2020 (input) will not correctly output using the Custom Format of m-yyyy, why is that?

[atcodedog05 · Accepted solution]

Hi @AFerency 

Why dont you try MM-yyyy

[AFerency]

I promise I tried that before and it didn't work but of course it works NOW! 🙂

Thanks for solution.

[atcodedog05]

Hi @AFerency 

If you look closely in the options in DateTime tool

m is actually minutes and not month.

And Month needs to be taken as MM 2 digits.

Hope this helps 🙂

[atcodedog05]

Happy to help 🙂 @AFerency 

Cheers and Happy Analyzing 😀

[AFerency]

So it seems I was trying mm-YYYY first, instead of MM-yyyy.

Thanks again! The captial letters in different spots made all the difference.