Table with exam dates using dataview?

[ObsidianAddict]

Hi

What I’m trying to do

I would like to build an overview of different exam dates.
I have several courses.
And each course has several dates on which you can take the exam.

I would like to have two different tables.

One shows each exam date across courses in the chronological order.
For example:
first row: Math, 20.10.2024,
second row: Physics, 13.12.1024,
third row: Math, 18.12.2024.

In the second table each course would have its on row, after wich all of the exam dates for this course are listed in chronological order.
for example:
first row: Math, 20.10.2024, 18.12.2024;
second row: Physics: 13.12.2024.

I would strongly prefer to use the date format as shown, so dd.MM.yyyy .

Ideally both tables would only show exam dates that have not yet passed.

Ideally I would only have to safe the exam dates in one type of property for both tables to work.

Things I have tried

Ive tried using the property type “list” to save all of the exam dates for a specific course.

This is my code. “klausurtermine” is just german for “exam_dates”:

table
klausurtermine
from #klausurtermine 
flatten klausurtermine
sort klausurtermine asc

This does produce a table, with separate exam dates. But it doesnt show the dates in chronological order. It only sorts them chronologically from the first number or number wise. But it doesnt consider the whole date. I tried different formats format for the date, but so far I am more confused.

For the second table I tried to save all exam dates as individual propertys. I used the property type date and named them 1.exam_date, 2.exam_date etc.

This is my code. Again “klausurtermine” is just german for “exam_dates”

table 
1.klausurtermin, 
2.klausurtermin, 
3.klausurtermin

from #klausurtermine 

This builds a table and does pull in the relevant files. But it doesnt show the exam dates in the table.

I would be thankful for any pointers how I could accomplish this!

[holroy]

You say nothing on how you store the subject and exam date in your source files. Without that is hard to help you.

How do you define your klausurtermine?

[ObsidianAddict]

I store it in the YAML frontmatter. And I create the frontmatter using the interface in the right side bar, where you can add properties. The course title is equivalent to the name of the note, so I dont store it in the properties.

This is the Yaml frontmatter for example:

I used the property type “date” for 1., 2., 3. Klausurtermine.
At the bottom the property type is a list. Here I tried using only numbers as dates, to see if it would help with the chronological order.

Does this help?