Replace nulls in DateTime field with blank/empty?

[mb1824]

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 solution]

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