Ajax Event Calendar Support Product Page

Only Events with stoptime?

Asked 28 Jan 2010 15:46:13
has this question
28 Jan 2010 15:46:13 Jacques H posted:
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


Replied 29 Jan 2010 12:14:18
29 Jan 2010 12:14:18 Seb Adlington replied:
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", "'", "''"

Reply to this topic