I'm trying to conditionally return a date value. The function works, however, the value is being returned as a text, and therefore defaults to the native SQL date format of YYYY-MM-DD. I'd like to be able to format the output to mm/dd/yyyy. If I were able to set the true condition to null, would this allow Metabase to "see" the output as a date?
I even changed the table metadata to a date option rather than "no semantic type," thinking that this might help, but apparently not. There also isn't a format([calculated_date],"mm/dd/yyyy") option which might work if it were available. Not the end of the world, but it would be nice to have a consistent date format across all the columns.
What happens if you reverse the logic to <>, then put Last_Receipt_Date first. Followed by null?
I've had oddities in Postgres where it assumes a null should be a certain data type.
Thanks for the suggestion. The issue seems to be that Metabase won't accept NULL as a valid option, at least not within the GUI editor. I could probably re-write the whole thing in SQL, but there are a lot of columns to this one question, so probably not worth bothering over the formatted output of a single column.
Unless the Metabase developers want to add NULL as an option or give us a format() option for a custom column, hint, hint!
