Forum Discussion
ModernAchilles
Helper I
Helper IChange 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!
Thanks so much!
Hi, looking in this link:
Create a Customcolumn :
#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, [datetime])
Regards
2 Replies
- Vvelarde
Community Champion
Hi, looking in this link:
Create a Customcolumn :
#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, [datetime])
Regards
ModernAchillesPerfect! Worked great, thanks so much!