+ Reply to Thread
Results 1 to 3 of 3

Power Query convert Unix time to a date

  1. #1
    Registered User
    Join Date
    03-20-2015
    Location
    England
    MS-Off Ver
    2010
    Posts
    3

    Power Query convert Unix time to a date

    I am new to Power Query and am struggling to find a way to convert a column of Unix Times to a conventional date; eg.

    ID UNIX DATE
    1 631152000 1-Jan-1990 00:00:00

    I can see that there are lots of Date/Time functions but having googled for half an hour I cannot find anything that will convert Unix Timestamps to a normal date.

    Can anyone help?

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,468

    Re: Power Query convert Unix time to a date

    It's difficult to tell with your formatting which data is in which field.

    Use [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags to better identify. (Or use the # in the toolbar)

    Is it the first or the second?

    Please Login or Register  to view this content.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Registered User
    Join Date
    03-20-2015
    Location
    England
    MS-Off Ver
    2010
    Posts
    3

    Re: Power Query convert Unix time to a date

    Your first one is correct - 3 distinct columns

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro to convert Power Query Worksheet to standard workbook
    By Brawnystaff in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-01-2015, 01:34 AM
  2. [SOLVED] Displaying Unix time as date and time
    By evangarich@gmail.com in forum Excel General
    Replies: 1
    Last Post: 05-30-2006, 05:35 PM
  3. Convert Unix timestamp to Readable Date/time
    By Emily in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-26-2006, 08:00 PM
  4. [SOLVED] Date to Unix time stamp?
    By Newbie in forum Excel General
    Replies: 2
    Last Post: 07-20-2005, 08:05 PM
  5. Excel Date Time to Unix Time
    By jnorton in forum Excel General
    Replies: 2
    Last Post: 05-24-2005, 02:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1