<div>
Perfect - thank you - very much appreciated.<br />
<br />
Just out of curiosity, if I had a client in another part of the World (we are in the UK), would I to run any other checks?<br />
<br />

</div>


Perfect - thank you - very much appreciated.

Just out of curiosity, if I had a client in another part of the World (we are in the UK), would I to run any other checks?



<div>
Yeah. &nbsp;The only bad thing about this function is that it has to use static start/end dates for DST. &nbsp;I'm honestly not sure how you would set it up for clients that span multiple regions with different DST start/end dates. &nbsp;I would assume that you would need a table somewhere that defined where each client was located and have logic built into the function to support that.
</div>


Yeah.  The only bad thing about this function is that it has to use static start/end dates for DST.  I'm honestly not sure how you would set it up for clients that span multiple regions with different DST start/end dates.  I would assume that you would need a table somewhere that defined where each client was located and have logic built into the function to support that.

<div>
What a pain. &nbsp;Thanks for all of your help on this.
</div>


What a pain.  Thanks for all of your help on this.

<div>
<div class="content wysiwyg-content">
I have an Access database that creates iCalendar/vCalendar files. &nbsp;The files are created correctly, but if Daylight Saving Time is in operation it adds an hour to the time when opened in Outlook. &nbsp;<br />
<br />
This was working fine, until the clocks went forward a few weeks ago.<br />
<br />
Any ideas?
</div>
</div>


I have an Access database that creates iCalendar/vCalendar files.  The files are created correctly, but if Daylight Saving Time is in operation it adds an hour to the time when opened in Outlook.  

This was working fine, until the clocks went forward a few weeks ago.

Any ideas?

Detecting if Dayligh Saving Time within Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.