Dataview query to show task in table not working

I have the following task

- [%] [subject::Sub 1] [module::1] [lectureNumber::1] [startTime::00:00] [endTime::02:00] #study/lecture #study/concept  #study/time-log

I am using following query to view the tasks as table

~~~dataview
table without id
    date("1970-01-01T" + task.endTime + ":00") - date("1970-01-01T" + task.startTime + ":00") as "Duration",
    task.subject as "Subject",
    task.module as "Module",
    task.lectureNumber as "Lecture",
    task.startTime as "Start",
    task.endTime as "End"
from "Main/Journal/daily"
FLATTEN file.tasks AS Tasks
~~~

It can find the tasks but the data is not displayed in table. See the output screenshot, specifically Duration (2) part.

Does this work?

~~~dataview
table without id
    date("1970-01-01T" + Tasks.endTime + ":00") - date("1970-01-01T" + Tasks.startTime + ":00") as "Duration",
    Tasks.subject as "Subject",
    Tasks.module as "Module",
    Tasks.lectureNumber as "Lecture",
    Tasks.startTime as "Start",
    Tasks.endTime as "End"
from "Main/Journal/daily"
FLATTEN file.tasks AS Tasks
~~~

These tasks are stored in daily note which has date in frontmatter. Can I display date field from the file ?

Is there a way to edit the task directly from table ?

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