What I did was to convert the query to an array, use dateformat on the field(s) that I
wanted to be formatted, and then convert back to a query. This is not the most
elegant solution seeing that when the user creates/modifies dates in the grid, there
is no restrictions on what they enter. Also the code can get a little cumbersome. If
you need help on my brief outline of what do to, feel free to write me back.
-----Original Message-----
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 20, 2001 5:47 AM
To: CF-Talk
Subject: formatting question
does anyone know how to put a date/time format on this field?
<cfgridcolumn name="OpenDate" header="Opened">
right now it displays like...2001-08-22 19:37:51
i want it to be 08/22/2001 7:37pm
*************************************************
This e-mail, including any attachments, is intended for the
receipt and use by the intended addressee(s), and may contain
confidential and privileged information. If you are not an intended
recipient of this e-mail, you are hereby notified that any unauthorized
use or distribution of this e-mail is strictly prohibited.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists