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
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
worked...thanks so much