Forum Discussion
Preserving Date format without 12:00:00 AM
Hi, I have large table that I need to export out of Desktop into csv for some users. Even though I used Power Query to change everything to a type of date, when I go to export this into CSV I get t...
Hi Anonymous
You can use the Format function to enforce a specific format on the date column.Column = FORMAT('Table'[Date],"mm/dd/yyyy")Result:
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
parry2k
Super User
Super UserAnonymous change the format of the date column without time from the format drop down list.