I have date as a string like '1.1.2023' which I need to convert to a datetime.
I use 'convert text to datetime' with custom format 'dd.MM.yyyy'
But this chokes and errors anytime day or month is a single digit value like '1.1.2023'.
Works fine when the date and month happen to be over 10 like '10.10.2023' or have leading zeroes like '01.01.2023'.
Manipulating the text like that is a pain in the ass, is there some way I can make converter understand this format?
