Can someone provide me with the SQL querry that this module uses to show the End Date and Time?

I am trying to create a custom view with SGSV and I am having some difficulty getting the End Date and Time to show correctly.
Thanks...

There is several ways to show the End Date and time using SGSV (SQLGridSelectedView - available at www.tressleworks.ca ).  As noted in the above post you can recalculate the end date by calculating the start date + duration using dateadd.  This will return a DateTime value from the query as would the Event End Date.

To format the datetime value, you can use the Convert function in T-SQL to convert the date to a string (varchar) or you can use the Column format option in SGSV.

The SGSV column format can be a bit tricky -- but for a date centered in the column use ,c,,,{0:<dateformat>}, where <dateformat> is a Standard .Net Date format string.  For example ,c,,,{0:dd-MMM-yy HH:mm}  will return 26-OCT-09 11:48 in centered the column. 

Please see the SGSV Usergide for complete details on column formatting.  If you have addition questions about SGSV, please post the question in the SGSV forum and I will be happy to help you.

Hope this Helps
Paul.