Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
Tips and Tricks
  • PC2790's avatar
    PC2790
    5 years ago

    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

PC2790's avatar
PC2790
Community Champion
5 years ago

Looks like it is interpreting the date as dd/mm/yyyy.

Can you check if it is only happening with the dates having mm value as > 12.


Also, please check your Locale settings by clicking on the column and selecting option - "Using Locale".

It should show you the format it is expecting:

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
      PC2790
      Community Champion
      5 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        worked...thanks so much