Everything not sorting customn column by dates logically

[anmac1789]

I have a custom column with this formula:

column1:=IF(ISBLANK($date-taken:),formatfiletime($media-created:),formatfiletime($date-taken:)) sort:column1-ascending

but some of the earlier dates are appearing after the later dates (in the screenshot):

Screenshot 2024-06-16 142543.png (302.05 KiB) Viewed 1203 times

[Phlashman]

looks like it is seeing the date as string which is mm-dd-yyyy, so it it sorting by month, then day, then year. to sort by date the string
needs to be yyyy-mm-dd

[anmac1789]

looks like it is seeing the date as string which is mm-dd-yyyy, so it it sorting by month, then day, then year. to sort by date the string
needs to be yyyy-mm-dd

that would also change the date string for date modified and those fields as well as customn columns. when the date modified is displayed differently, it still sorts the date modified logically but the custom column date is sorted not following the same logic as date modified (or date created or date accessed or date taken). Is it because of the fact that everything by default, sees the custom column as text string instead of date string ? How do I have a custom date string just for custom column separate from changing also the date modified fields as well ?

[void]

Currently, Everything sees the custom column as a text string instead of a date string.

Please format your custom column to get the desired sorting.

[anmac1789]

Currently, Everything sees the custom column as a text string instead of a date string.

Please format your custom column to get the desired sorting.

understood thank you for clarifying