Thanks for your help. I was wondering how this module handles changes in the event data? I.e. If I change something in DNN like delete an event, it doesn't seem like the event gets deleted on my google calendar.

Mr. Cullman,

Thanks again for your help. The awesome thing about this module and syncing with google calendar is that it also is an indirect way to get an ICS format for a DNN Events calendar.

I used this SQL to get my DNN Events calendar data:

SELECT [EventID]
      ,EventBegin = [EventTimeBegin]
      ,EventEnd = [EventTimeBegin] + CAST ([Duration] AS float)/(24*60)
      ,[EventName]
      ,[EventDesc]
      ,[AllDayEvent]
      ,LocName = ISNULL(c.LocationName, '')
  FROM [gcl-dnn].[dbo].[Events] E
  left outer join dbo.[EventsLocation] c ON E.Location = c.Location
  where E.ModuleID = YOUR DNN EVENT's MODULE ID

This works OK except it seems to not account for the time zone. Any ideas on how I need to change it?

Thanks,
John