denstar wrote: > Are they against letting you add a real date field? Seeing there's already several hundred records in the database, some with dates, some with NONE - which is exactly what they want - adding a real date field would be tough. It was a hard argument to start with, and I let them win.
> Perhaps add a date field, and then make some magic that turns those integers > into dates. Yea - but how do you turn 0/0/2007 into a valid date? And *what* date do you turn it into if you replaced the "0" values with something else? And what if they don't enter a year at all? 0/0/0??? Ack! But - see my other email. I've had an idea while watching "House"!! Sometimes getting out from in front of the computer is the best way to find a solution (maybe - haven't tried it yet)!! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301974 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
