Dataview date format setting doesn't work

[Lemon8686]

Hello everyone.

I prepared a dataview table taking dates from various notes.
The dates are stored in the YAML header as a tag called “wDate”.

Note 1:

wDate: 23/02/23

Note 2:

wDate: 23/02/2023

I have set this option in dataview’s settings page, as I want all dates to have the same format:

However, when I create a table showing all these dates, they all seem to be in whatever format I input them in rather than follow the same one.

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.

Is there something I am missing?

[Guapa]

Hello.

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

---
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 
```

And here is the same query with the Dataview settings changed to cccc, dd MMMM yyyy