I have a column with dates formatted as text, missing values are marked with
I would try and use
isDate() as an alternative:
Notice that I have swapped the true and false part around in the
iif() as the expression has changed.
Although, if the only alternative to a date is the dash
- symbol, which you have used in the first expression I believe that the
IsNumeric() function would also work.