Uh... #dateFormat(theDate,'yyyy.mm.dd')# On Jan 2, 2008 3:02 PM, Mark Fuqua <[EMAIL PROTECTED]> wrote:
> I have to use dates in an xml document. The date comes from the database > like so. > > > > 2008-02-01 00:00:00.0 > > > > I need to get rid of the time and replace the dashes with periods to make > the format as follows: > > > > 2008.02.01 > > > > This will be done inside a query loop of maybe 30 records with two dates > each. Is there a regular expression that can do this or should I pull > date > parts out? > > > > Thanks, > > > > Mark > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:295715 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
