I am VERY new to OpenEMR and queries in it. I found a format in the community (thank you!) that is close to what I am trying to accomplish, however, when I run it - it does not like the date. I have tried different variations and still receive the following: “Error in query (1054): Unknown column ‘‘2022’ in ‘where clause’” - Can anyone help? See below.
openemr_postcalendar_events on patient_data.pid = openemr_postcalendar_events.pc_pid
order by openemr_postcalendar_events.pc_startTime asc