FWIW let CF do the formatting for you, store it the way the DB handles it. On Feb 19, 2008 5:29 PM, Will Tomlinson <[EMAIL PROTECTED]> wrote: > In MySQL 5, I'm storing a date in a date field. It stores it as 2008-19-2. > > But my client wants to let users filter records using this format: > 02/19/2008 > > What's the best way to convert the format my form uses to something mySQL can > read. > I'll be looking for records between two dates, etc. > > Thanks, > Will > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:299362 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
