doesn't matter what the date looks like in the database. format it when you output it using dateFormat().
you should still be using a date/time datatype tho...NOT text. On Sun, 27 Feb 2005 16:47:14 -0500, Roberto Perez <[EMAIL PROTECTED]> wrote: > Hi all, > > Quick question: I'm passing the date to an Access database. I have set the > field "DateCreated" in Access as Date/Time, and I've chosen a given date > format within Access. However, it seems to be that the field just takes the > format ColdFusion sends the date in, regardless of what format I've chosen > in Access. > > My question: am I better off setting that field to text and create my own > format in Cold Fusion, or is there a real need to/advantage in using the > "date/field" type, even with it's limited formats? > > Thanks in advance, > > Roberto Perez > [EMAIL PROTECTED] > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196766 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
