Forum Discussion

bdehning's avatar
bdehning
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

Null Vales and Time Column

Is there a way to replace null values with other text in a Time Column?       When I use the column for a Table, it shows all nulls as Blank and I would like other text.   
Show and Tell
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, bdehning 

     

    The data type of a column has to be the same. The value in the middle of the time column cannot be converted to a text value.

    Column = IF([Time]=BLANK(),TIME(0,0,0),[Time])

    Does this solve your problem?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
4 years ago

Hi, bdehning 

 

The data type of a column has to be the same. The value in the middle of the time column cannot be converted to a text value.

Column = IF([Time]=BLANK(),TIME(0,0,0),[Time])

Does this solve your problem?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.