Cast columns as different types in Custom Fields

It should be easy to change a varchar to a date or a char to a number using the cast command; avoiding the need to create a view for just a single field format.

Can you please implement the CAST() function

1 Like

Hi @PhilBailey
It’s a bit more complicated, since the Custom Expression options are not equivalent to your database functions, and Metabase works with 15+ different database types, which each have their own functions.
There’s a few open requests - upvote by clicking :+1: on the first post of each issue
https://github.com/metabase/metabase/issues/11330
https://github.com/metabase/metabase/issues/12938
https://github.com/metabase/metabase/issues/14054