Forum Discussion
Date conversion
I've imported a csv file into Power Query and have a field predominantly for dates in yyyymmdd format, but where there isn't a date, it's showing as blank. how do I create a normal date format dd...
That gives me the date in the format I want it. But in the original import, blanks became null. So I want to get rid of the null and leave those as blank
Thanks
audreygerred
Super User
Super UserI don't believe you can change a record to blank when the field is formatted as Date. A common practice I see is replacing the nulls with a date that is obvioulsy not correct (such as 1/1/1900). Also, if you leave as null, it will still appear as a blank in the viz (see top row of below viz).
I'll leave it as null then and convert the date to normal format.
Thans for your help