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 2289 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

[void]

Everything 1.5.0.1384a adds support for formatting custom columns.



For example:

Code: Select all

<date-taken: column1:=$date-taken:> | <media-created: column1:=$media-created:> add-column:column1 sort:column1-ascending column1-format:datetime

This will sort your results correctly by FILETIMEs and display the column 1 values as a datetime.



Supported column formats:

• size:auto
• size:bytes
• size:kb
• size:mb
• size:gb
• size
• duration
• length
• number
• attributes
• filetimeutc
• filetime
• datetime
• date
• time
• Any Text() format. For example:
  YYYY-MM-DD
  or
  #,###