Forum Discussion
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!
v-yuta-msft
Community Support
Community SupportHi ducpham,
Have you solved your issue by now? If you have, could please kindly mark my answer as a solution?
Regards,
Jimmy Tao
One way you can do it is create a new column:
Let's assume the column reference with your date values (i.e. 42917) is called Date[Old Date]
New Date = Format(Date[Old Date],"mm/dd/yyyy")
If interested, a similar operation can also be done in Power Query.
