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
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;luxon
tokens to define the wanted output - luxon tokens
In your case, try dateformat(file.cday, "cccc") AS Date
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.