Skip to main content
M
mtgna
Participant
January 31, 2009
Question

Formatting date

  • January 31, 2009
  • 1 reply
  • 383 views
Hi
I am trying to set up a Flex application with Coldfusion.

I set up a database table in MS SQL Server, one of the columns is date [datetime]
When I use Coldfusion to retrieve the data through a RemoteObject from using the getAll() functions (generated by CFC Wizard) Flex output the following date format in a datagrid.

Mon May 10 00:00:00 GMT-0700 1976

Can anyone please suggest how I can convert it into dd-mm-yyyy format? I have searched for hours on the internet without success.

Thanks
This topic has been closed for replies.

1 reply

A
Anonymous
January 31, 2009
I'm not sure if Flex changes anything but in straight CF you would use:

#DateFormat(dated_on, "dd mmm yyyy hh:mm")#

dated_on is the name of the column in your table that is holding that info.

This from http://livedocs.adobe.com/coldfusion/6.1/htmldocs/functi59.htm
M
mtgnaAuthor
Participant
January 31, 2009
Thanks for your suggestion. I found an easier fix in Flex.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices