Replacing null with a blank DateTime Value

[hhammeren]

I have a column that is of DateTime format and I want to replace all the null values in the column with a BLANK cell.  I am recieving an error message that tells me I have to enter a DateTime Value in order to compare cells with the same format when I later create a calculated column. 

Is there a blank version of the DateTime value I can enter in the "Replace With" box?

Thank you in advance.

Hannah

[v-sihou-msft · Accepted solution]

@hhammeren

What's the data type of your DateTime format column?

If it's already a "DateTime" data type, don't replace the null values into blank, otherwise the data type will change to "Any". The null values will not impact your calculated column.

Regards,