Blank constant/functio in formulas

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.

1 Like