2 Replies Latest reply on Jan 30, 2009 9:28 PM by John Hall

    Formatting date

    mtgna
      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 a simple dd-mm-yyyy format? I have searched for hours on the internet for a solution without success.

      Thanks
        • 1. Re: Formatting date
          Level 7

          "mtgna" <webforumsuser@macromedia.com> wrote in message
          news:gm0eg6$90k$1@forums.macromedia.com...
          > 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 a simple dd-mm-yyyy
          > format? I have searched for hours on the internet for a solution without
          > success.

          Doesn't SQL Server SQL have a DateFormat function or something?


          • 2. Re: Formatting date
            John Hall Level 4
            See if this kind of approach works for you: