DateTime tool outputting incorrect month

[HBarge]

Hi,

The date time tool is outputting incorrect month when converted from string to date time.

What might be the reason? Is there a workaround/solution?

[Thableaus · Accepted solution]

Hi @HBarge 

Instead of "mm" in your datetime format, try "MM".

MM stands for month. mm for minutes, that's why you're getting wrong results.

Cheers,

[HBarge]

Thank you.