It appears that event calendar will only show items when stoptime is inserted as well. Starttime will interpret inserted time as GMT instead of local time and thus will show inserted time +1HR in my case.
As most events do have a starttime, but not a stoptime I would like to see that calendar responds to only starttime as well

Edited by - Jacques Hoogenboom on 28 Jan 2010  15:47:19

Edited by - Jacques Hoogenboom on 28 Jan 2010  17:26:11

Hi Jacques,

I was having the same trouble, in that I would never use an end time - I tweaked the sql select command to get around it, but it would be cool if this was automatic - you could use the same to take an hour off..

"SELECT [TranportTo] AS title, DATEDIFF(second,{d '1970-01-01'},[TransportDate]) AS start, DATEDIFF(second,{d '1970-01-01'},DATEADD(hour,1,[TransportDate])) AS stop , [TranportTo] AS description, [Status] AS type, [ID] AS event_id FROM [SebGINHeader2] WHERE DATEDIFF(second,{d '1970-01-01'},[TransportDate]) <=" & Replace(Request.QueryString("stop", "'", "''" & " AND DATEDIFF(second,{d '1970-01-01'},DATEADD(hour,1,[TransportDate])) >=" & Replace(Request.QueryString("start", "'", "''"