Forum Discussion
frknklcsln
Helper II
Helper IIhow to change text date to date format
Hi, I want to change text date format to dd/mm/yyyy format. My date is 44799 (stored as text) when its coming from Excel file. I want to change it to 26/08/2022. How can I convert it by writi...
frknklcsln , if change the format of this in power query or DAX to date, It should show you the date
Or try like
Date(1900,01,01) + [Date as number]
or
format(Date(1900,01,01) + [Date as number], "DD/MM/YYYY")
amitchandak
Super User
Super Userfrknklcsln , if change the format of this in power query or DAX to date, It should show you the date
Or try like
Date(1900,01,01) + [Date as number]
or
format(Date(1900,01,01) + [Date as number], "DD/MM/YYYY")