Definitely store it as a date. What about time? Do you ever foresee the need to know the time of an event? If so, use a datetime to store it.
And if an event doesn't have a time, while others do, use a standardized "placehlolder" like midnight to designate "don't care" on the time object. Jerry Johnson >>> [EMAIL PROTECTED] 10/15/02 01:25PM >>> I am creating a calendar of events database & CF app from scratch.. An initial question that comes to mind is.what is the best way to store event dates for this.using separate fields called something like from_day, to_day from_month to_month from_year to_year OR - should I somehow just use two fields.one for the "from date" (ex. 3/12/02) and one for the "to date" (ex. 3/13/02) I'm trying to think ahead to the customer making calendar changes and displaying the calendar Could anyone with experience creating this type of event calendar share their thoughts on this? Thanks in advance Tim Laureska ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
