2 Replies Latest reply: Dec 20, 2013 7:34 AM by paraih1 RSS

    Problems converting FILETIME date/time into MM/DD/YYYY format...

    Adobe Forums User Community Member

      Has anyone successfully converted a FILETIME date/time value into a MM/DD/YYYY format using ColdFusion? I am failing drastically, and it seems like an easy conversion.

       

      FILETIME format (details: http://msdn.microsoft.com/en-us/library/windows/desktop/ms724284(v=vs.85).aspx) is a 64-bit value representing the number of 100-nanosecond intervals since January 1, 1601 (UTC).

       

      A database I'm working with has such values, and I want to display them in a user-friendly date format within my application.

       

      For example, one record is:

       

      13003368600

       

      The above number represents the following date and time:

       

      1/22/2013 @ 2:50 PM

       

      Sadly I know this only because the FILETIME value gets written to the database by a third-party application, and within that application I specify it in the MM/DD/YYYY format.

       

      Can anyone offer me some guidance, or better yet has anyone accomplished this already and want to share code?