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:




      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?