How to replace "?" in a date time field with null

Hi - I am stuck where I am getting “?” (missing values) in a table and I have to replace them with null or 0.

I am able to do it from a String type and integer type using missing value node.

But I am unable to do so for a field with DateTime type.

Can anyone suggest something out here?


Hi @rahul.kalra,

since null or 0 are no valid values for a DateTime cell, you cannot set it to null or 0.

If you want to set the missing value to a fixed value though, you can use the Date&Time to String and String to Date&Time nodes to convert the column to a String column and back, so that you can replace the intermediate String with the Missing Value node with a valid missing value.


Thanks Simon