Dataview sort by formatted file.cday

Help
1

What I’m trying to do:

Sort a list of filenames by creation date and format the shown date.
How do I format the variable “fdate” to YYMMDD?

Problem

Can’t format.

Things I have tried, this does sort, but how to format “fdate”:

TABLE file.cday as fdate, prio as Prio, frist as Frist, tags as Tags
FROM (#literatur/todo and #stichwort )
WHERE prio >=4
SORT prio DESC , frist DESC , file.cday ASC, file.name ASC

2

Found :slight_smile: :

TABLE prio as Prio, frist as Frist, tags as Tags, dateformat(file.ctime, "yyMMdd:hh") as "fdate"
FROM (#literatur/todo and #stichwort )
WHERE prio >=4 
SORT prio DESC , frist DESC , file.cday ASC, file.name ASC
3

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