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
FrankAT's avatar
FrankAT
Icon for Community Champion rankCommunity Champion
6 years ago

Hi ducpham 

the whole number 42917 interpreted as date is the 42917th day since 01/01/1900 => 07/01/0217 (mm/dd/yyyy). You can convert this serial number in Power Query:

  1. Select the column with the whole number.
  2. Change date typ to date.

Or you can convert the column with the serial number in DAX like this:

 

 

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)