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 ]]. 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?