ODBC guide

List events for today and tomorrow with dynamic placeholders

Use dynamic placeholders to query events starting from today and ending tomorrow. <> is today's start, and <> is tomorrow's start. This example combines static time ranges with dynamic dates for precise filtering.

Advanced Tip: Adjust the offsets (e.g., +1d for tomorrow) to customize the range.

SELECT * 
FROM Events
--FROM EventsAll --(Get from All Calendars)
WITH (CalendarId='primary',
      StartTime='<<today,FUN_TO_DATETIME>>-05:00',   
      EndTime='<<today+1d,FUN_TO_DATETIME>>-05:00')