I am creating a timer job for SharePoint 2016 on premise calendar event task. The function is to send reminder email to event attendees 1 day prior to event occurrence. I am creating a timer job to fetch the event attendees list (start time-date time field(need only date)) which is going to occur on next day and send email to attendees.
I created a CAML query to fetch the attendees who has events the next day in order to send email reminder 1 day prior but it is not working.
Using VS to create the timer job.
My query:
sPQuery.Query = "<Where><Eq><FieldRef Name=\"Start_x0020_Time\" /><Value IncludeTimeValue='FALSE' Type=\"DateTime\"><Today OffsetDays = 1/></Value></Eq></Where>";