Dataview query - use of inbuilt date function

What I’m trying to do

I’m trying to obtain a list of meetings and their topics which are taking place in the future. Bespoke inline fields have been created for aspects of the meeting.

table event_type, event_title, event_date from ""
where event_type = "👥meeting" and date(event_date) >= date(today)
sort event_date asc

The code incorrectly all meetings whether past or future.

Event_date is in a bespoke format, prefaced by the week number, as follows [[wk20 2021-05-18 Tuesday :calendar:]]. My understanding is the that the “date” function is able to extract the date from the bespoke format as long as it is in the form YYYY-MM-DD format, which is the case. However, this query lists all past meetings.

Can anyone tell me what I’m doing wrong?


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