DATAVIEW - DATE as a unique property name

Trying to sort readwise references and run into a issue sorting by date (which actually has the property name “LastHL”)

How can I get the sort function to treat LastHL as a date instead of a number, or whatever it thinks it is here.

TABLE LastHL AS Read, Note
WHERE Class = [[References]]
SORT LastHL DESC

I’ve tried a range of things and am lost!

You could try the following sort line: SORT date(LastHL, "d.M.yy") desc, so date will try to interpret a date from that field according to the specified format.

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.