Hi I have written following code to display date.. <cfquery name="getDate" datasource="DSN_Test"> select D_DATE from employee </cfquery> <cfoutput query="getDate" > #D_DATE# </cfoutput> but in CFMX environment it shows : 2003-04-30 00:00:00.0 (milli seconds format.. Its java locale standard date format. Default format.) In CF5.0 Environment it shows : 04/30/2003 00:00:00 (normal format) So here my question is that can we change this default milliseconds format to normal format in CFMX environment with out writing the code.. I know that we can write the code to convert one format to another..but we have a lot of places in another files.. so is there any file where we can change default format to normal format in globally.. it should reflect in all cfm pages too.. Thanks in Advance.. Best regards Ramesh
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

