Forum Discussion
CONVERT TIME FORMATS
Hey Guys, I have a column with 24 hour date time values like this 10/02/2020 21:18:39 Which parse fine. How ever there are some values that look like this 10/14/2020 10:16:02 PM an...
That's where the issue lies.
See the expected format of Date for United Kingdom(dd/mm/yyyy):
However the date you have is in format-mm/dd/yyyy.
Can you try changing it to English(Unites States) and see if it fixes your issue?
Thankyou
So it turns out the date is actually the issure like you said but i have selected to correct Date Time Locale which is UK but i still have those errors.
Any Ideas?
PC2790
Community Champion
Community ChampionThat's where the issue lies.
See the expected format of Date for United Kingdom(dd/mm/yyyy):
However the date you have is in format-mm/dd/yyyy.
Can you try changing it to English(Unites States) and see if it fixes your issue?
Thankyou
worked...thanks so much