Forum Discussion

hhammeren's avatar
hhammeren
Frequent Visitor
9 years ago
Solved

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 i...
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    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,

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

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,