I was under the impression that the aforementioned option would make it so all the dates in a dataview table would be formatted in the same way, but maybe I am mistaken.
Dataview settings (example) date format yyyy-MM-dd-cccc
In the query below, Date2: 2023-02-01 shows the date as 2023-02-01-Wednesday, with the day of the week added to show how the query is working
Dataview reads the Date2 key–value pair as a date because it uses the syntax that computers recognize as being valid dates (see point 5 below)
In the same query, Date: 01-02-23 just shows the original string of numbers because Dataview doesn’t know that the string of numbers is a human-readable date
---
Date: 01-02-23
Date2: 2023-02-01
Tags: test
---
1. Dataview settings (example) date format `yyyy-MM-dd-cccc`
2. In the query below, `Date2: 2023-02-01` shows the date as `2023-02-01-Wednesday`, with the day of the week added to show how the query is working
3. Dataview reads the `Date2` key–value pair as a date because it uses the syntax that computers recognize as being valid dates (see point 5 below)
4. In the same query, `Date: 01-02-23` just shows the original string of numbers because Dataview doesn’t know that the string of numbers is a human-readable date
5. If you want Dataview to automatically recognize dates, you need to use [text that matches the ISO8601 notation](https://blacksmithgu.github.io/obsidian-dataview/annotation/types-of-metadata/#date)
```dataview
TABLE
Date,
Date2
FROM #test
```
