Fine creation Day Name in Dataview

I use file.cday AS "Date" to fetch the date in a dataview table.

It fetches date like

November 10, 2022

I want just want the day name of the file creation, i.e

Sunday

Tried date(file.cday), is there a date(file.cday).format ? Please help

Use:

  • dateformat() to format the output of date values because the default output format is the one defined in settings > dataview;
  • use luxon tokens to define the wanted output - luxon tokens

In your case, try dateformat(file.cday, "cccc") AS Date

1 Like

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