Replace datetime column value with null or missingvalue

[Jeff]

Hi,

I have a column that contains datetime values. Someone used 1900-01-01T00:00 as a null value. I need to replace it with null/missing value. Searching the community/web I don’t see what node to use. I’ve tried using column expression such as replace(column(“MyDate”),“1900-01-01”,missingvalue()) but that doesn’t work.

Any ideas?
Jeff

[SimonS]

Hi @Jeff,

You can use a String Manipulation node with
toNull(replace($MyDate$, "1900-01-01T00:00","")).

Cheers,
Simon

[Jeff]

Thanks… appreciate the insight!