I do not get any error while passing a date range to ‘rev_rec_date’ in SQL runner, but getting an error ‘:invalid value for "YYYY" in source string’, when I do the same while defining a view. Attached are the shots. Please help

Trying to concatenate dimensions and separate them with a space or dash but when I add in the character the new concatenated string does not populate. Simple example - Dims - cat, dogfunction that does work: concat(cat, dog) = tabbypitbulldesired res...