I did it in the database. Depending on your database provider, could be the date_format() command, or something similar.
e.g. mysql: SELECT date_format(somedates.aDateTime,'%m/%d/%Y') as someFormattedDateField FROM somedates :d On 9/14/06, Patty Severski <[EMAIL PROTECTED]> wrote: > > Can I / How do I format the data that appears in > cfgrid? Specifically : #TimeFormat(Date, "HH:MM:SS")# > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253209 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
