Replace nulls in DateTime field with blank/empty?

Question

Hi,

How do I replace nulls in a DateTime field with a blank/empty?

The below doesn't work.

If IsNull([DateTime]) THEN "" ELSE [DateTime] ENDIF

MarqueeCrew · Accepted Answer

Dates can be Null or a valid ISO date.

YYYY-MM-DD

If you want spaces, then you need to change the data type to a string type.

Cheers,

Mark