Good morning. I'm building an application for a client (using Coldfusion MX 7 & MySQL) that allows users to schedule email reminders for themselves. When they schedule this reminder, they choose an event date from a calendar, .. specify the time of day, .. and then indicate specifically how many days before the event they'd like for the email reminder to be sent to them. This is simple enough to work with, as I can just use ColdFusion's built-in "DateDiff" function to create the proper date/time value. However, .. the client recently asked me how I would handle the user's different time zones, and I'm stumped as to what I should do.
First off, .. will it be necessary for me to include a "Choose Your Time Zone" select dropdown box in my form (used for scheduling reminders)? See this url for an example --> http://www.timeanddate.com/worldclock/converter.html
. Or ---- is there some way for me to automatically detect and extract the time zone from the user's workstation?
I need some guidance and examples on how I should calculate my date/time value based on the user's time zone. I'm open to using whatever methods are suggested. Any help is appreciated.
Thanks in advance,