All of the program code and information presented in the OpenNTF.org Code Bin are provided "as-is", and should be used at your own risk. OpenNTF.org make no express or implied warranty about anything in the Code Bin, and OpenNTF.org will not be responsible or liable for any damage caused by the use or misuse of anything from this site. OpenNTF.org makes no guarantees about anything. Please thoroughly test all of the knowledge and code you find here before you attempt to use them in your production environment.

This is a sample database which demonstrates an effective methodology for correcting daylight saving time problems in custom Notes applications. It was developed specifically for the purpose of cleaning up some home-grown room reservation databases, but can be adapted to pretty much any custom application with minimal customization.

The database itself serves as a central point of reference for tracking the dates when your users' workstations received the DST operating system patch, and for pointing to "DST Cleanup" views copied to the target databases, showing which documents are affected by the DST change. I've posted detailed guidelines for using this database and customizing the cleanup code on my blog here: http://www.lotusguru.com/lotusguru/LGBlog.nsf/d6plinks/KPET-6Z2GEL