cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ModernAchilles Regular Visitor
Regular Visitor

Change to a Date with 10 integer format

Hi,

 

I am having a hard time changing this 10 integer timestamp to a date format in Power Query. When I try and format differently with the drop downs it gives me an error.

 

I believe the database is returning a Unix 32-bit integer timestamp. If anyone know how I can convert this to a date that would be great!

 

Date.PNG

 

Thanks so much!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Vvelarde Super Contributor
Super Contributor

Re: Change to a Date with 10 integer format

@ModernAchilles

 

Hi, looking in this link: 

 

https://social.technet.microsoft.com/Forums/en-US/7a141fa1-4b2f-42ce-8e54-b90be781074e/calculating-d...

 

Create a Customcolumn :

 

#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, [datetime])

 

Regards

 




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

2 REPLIES 2
Vvelarde Super Contributor
Super Contributor

Re: Change to a Date with 10 integer format

@ModernAchilles

 

Hi, looking in this link: 

 

https://social.technet.microsoft.com/Forums/en-US/7a141fa1-4b2f-42ce-8e54-b90be781074e/calculating-d...

 

Create a Customcolumn :

 

#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, [datetime])

 

Regards

 




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

ModernAchilles Regular Visitor
Regular Visitor

Re: Change to a Date with 10 integer format

Perfect! Worked great, thanks so much!

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 367 members 4,436 guests
Please welcome our newest community members: