excel date formatting and sorting

[limzhiyangg]

I have a column of dates which is in the following format:

eg. '05-Aug-2020 04:24'

which shows the date month year, and then the time

How do I sort by date, I tried sorting it but i could only figure out how to sort it by the first two digits

[#2]

@limzhiyangg Why not upload a file with several dates as you have them. Perhaps they are in fact texts an then sorting will not give you the desired effect.

[#3]

Hi, this could be because any field could makes it a text field and so you are only able to sort it with the first 2 digits. (If you look at the filter option, it would show text filters)

You need to make sure the format is Date. You can use Custom Number format "dd-mmm-yyyy hh: mm" to display in the format you want. Make sure you have no am or pm displayed after the date and time.

[#4]

yes they are in text form, I tried to format them into dates, however, it does not work.
I tried formatting them while they are in the form ' Apr 20 2021 ' , but nothing happens.
But when i put it as '20 Apr 2021', the formatting process is successful