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:295713 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4