> My one thing to add here is that if you can re-work > the database to keep date and times separate, it might > be beneficial in the long-run. I've had problems in the > past creating daily reports because I didn't have > isolation of the date and time.
I can't imagine why storing the date and time in a single datetime field would cause a problem. It's easy enough to query the database to find only the date or the time value, if that's what you want to do. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
