dates

I have some issues related to dates that I can't wrap my head around.

There is a part of my site where people can set up a day and time for a chat, set using an insert record form.  The first thing is that I want to set the date using a drop down menu for 'month_for' 'day_for' 'time_for' 'am_or_pm'  and 'timezone' that information is stored in the table 'chat_setup' with the primary key 'chat_id'

Then, I have another insert record form that stores the users that want to be notified when the day/time approaches.  that table is 'chat_notify' with the primary key 'notify_id' and stores 'user_id' as well as 'chat_id' and 'daytimefor'

so that's how I have the insert record forms set up, but what I really want to do is figure out a way for coldfusion to take that information and email a user when the set up chat approaches.

If it makes it simpler, it would be fine to notify the user on the day the chat is set up for, taking time out of the equation...

Any idea how I should go about this?

Thanks!