Currently the only way to have a formula return
Blank is by either returning an empty string (
"") or by using an expression that itself returns
Blank, such as
List().First() (see this reply: Best way to get Blank? - #6 by artsafin).
Both feel hacky. Returning an empty string as part of a formula for a column of type Date, that implicitly gets cast to a Blank Date is awkward. I would much rather have a constant available in formulas that explicitly represents the null value in a type. Something like a
Blank keywork or a
Blank() function would do the trick.