Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. howdidigethere

    Convert UTC field into a 01/01/2003 12:00 AM (date time format)

    Before I read your last post I went in and created a timevalue function: @mytime TimeValue({UTC}/86400) This gave me the time. I then used your suggested DateAdd formula to come up with the date: @mydate Dateadd("d",int({UTC}/86400),Date(1970,1,1)) Then I created a concatenated...
  2. howdidigethere

    Convert UTC field into a 01/01/2003 12:00 AM (date time format)

    Thats getting close but I do need the time to pull as well. If you have any suggestions I'd appreciate. At least this has jump started my brain! I'm gonna go mess around with the formula some more. Thanks!!
  3. howdidigethere

    Convert UTC field into a 01/01/2003 12:00 AM (date time format)

    In excel I've done it so much it's just become routine. I import the UTC values into the A column, in the B column I put in this formula: (assuming A1 is where my UTC value is) =A1/86400+DATE(1970,1,1) This has always made me a happy camper... I just divide the UTC value by the number of...
  4. howdidigethere

    Convert UTC field into a 01/01/2003 12:00 AM (date time format)

    I think I've gotten to the point where my mind refuses to work anymore... I've got a date/time field (imported from Cisco's CallManager) that is in a UTC format (1009843200). I would like to create a formula that converts UTC format into a date and time format: 01/01/2002 12:00 AM. I have no...

Part and Inventory Search

Back
Top