Hi Mynda,
As I'm just taking the PQ course, I downloaded the Power Query Formula Language Specification, current version is October, 2016.
I see in the video "6.03 Using a Function to Add a Custom Column (0:07:58)", time reference 4:50, you had the February 2015 version, which shows the section 6.8 DateTime.AddZone.
The issue is that the recent Language Specification I downloaded doesn't have the same content since I can't find section 6.8.
Did I get the wrong PDF? Please help.
I used this URL: https://msdn.microsoft.com/en-us/library/mt807488.aspx
Thanks,
Pablo
Hi Pablo,
Indeed, the DateTime.AddZone is missing from october 16 specs, but you can find it online: https://msdn.microsoft.com/en-us/library/mt253514.aspx
In october 16 specs, you can find something you can use: it's the #datetimezone function, it has basically the same functionality:
#datetimezone( year, month, day, hour, minute, second, offset-hours, offset-minutes)
Hi Catalin,
Thanks for your response. I got it.
