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?
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!
Your first one is correct - 3 distinct columns
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks