Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Power Query: Remove TimeZone info

hi,   When I use this in my Power Query:     [createdon] + #duration(0,10,0,0)   I get a value that is returned as type 'Any'. The value looks like :   4/08/2018 6:45:24 AM +00:00   ...
Need Help
v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

Hi Anonymous ,

Could you have just tried to change the data type to "Date":

Regards,

Daniel He