Forum Discussion
Create a date column by adding milliseconds to previous date column
That is Unix Epoch time I believe, and that timestamp above is from April 9, 2020. You should ignore that +0000. Never convert Unix time with time zones. Always leave it at GMT, then convert it to your local time zone after you have converted it to the normal date/time in the GMT time zone. I explain this in my blog post where I show you how to handle this in Power Query. Let me know if you have any questions.
That is Unix Epoch time I believe, and that timestamp above is from April 9, 2020. You should ignore that +0000. Never convert Unix time with time zones. Always leave it at GMT, then convert it to your local time zone after you have converted it to the normal date/time in the GMT time zone. I explain this in my blog post where I show you how to handle this in Power Query. Let me know if you have any questions.
Many thanks - your article solved my problem!