CSV Calendar Export from Outlook

[cbsc]

I am hoping someone can help to clarify the following...

 

We are running Outlook 2010, running off an Exchange 2003 server (not that I think this matters).

 

Every year we carry out a CSV export of our main school calendar, which is in turn given to the company that manage our website to import into an online calendar. They haven't, up till now, had a facility to automatically sync between the two.

 

However we noticed that there is a problem with calendar events that are marked as an "all day event". The event displays correctly in Outlook, but when exported to CSV, the start date and end dates are different. For example:

 

OUTLOOK

 

Bank Holiday, All day event, 27/05/13

 

CSV EXPORT

 

Start Date - 27/05/13

Subject - Bank Holiday

Start Time - 00:00:00

End Time - 00:00:00

End Date - 28/05/13

All day event - TRUE

 

Am I right in assuming that the exported data is correct, and that actually there is no problem with the way Outlook/Exchange is handling the export? Interestingly I notice that when sending an appointment request via Outlook, the email contains similar information regarding the start date and end date (although once accepted, it appears correctly in the Outlook calendar).

 

Is it therefore a problem with the way the website company is interpreting the data their end, when importing it into their own calendar system.

 

Thanks!!

[sukh]

That looks good to me, seems like an issue at their end.

[cbsc]

That looks good to me, seems like an issue at their end.

 

Thanks for your reply!

 

So am I right in thinking that the start and end dates should be different, although the event only takes place on one day? i.e. this is by design

[sukh]

Correct, that is by design, it will have 2 dates.