Forum Discussion

MatildeBecherel's avatar
MatildeBecherel
Regular Visitor
2 years ago

How to change the date format?

Hello everyone,

 

I have a column with dates where half the column contains dates in mm/dd/yyyy format and the other half dates in dd/mm/yyyy format.
How can I do, via edit query, to put them all in the same format?

 

Can someone please help me?

 

Thanks!

Need Help

1 Reply

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    2 years ago

    Hi MatildeBecherel 

     

    Are you able to identify which dates are in which format, by using some other field in the table?  Or some other way?  Without a way to know this, I don't know any way to programmatically pur them all in the same format.

     

    Phil