Forum Discussion
Replacing null with a blank DateTime Value
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
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,
1 Reply
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,