Forum Discussion

ducpham's avatar
ducpham
New Member
7 years ago

Convert a date value like 42917 to date

Hi,   One of my columns is formatted as pure date integer like 42917. How do I convert it to date format yyyy/mm/dd ? Using any of the given date formats just give error.   Tks!
Need Help
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi ducpham,

 

So what's the meaning of 42917? Does it mean 1942/9/17 or 2017/4/29? No matter what does this value mean, you should do some preparation in power query before formatting using some power query function, please refer to: https://msdn.microsoft.com/en-us/query-bi/m/text-functions. 

 

Regards,

Jimmy Tao