I have a string column in my db called calendar_date, which i’m trying to keep as a string. Redash forcibly converts it to a datetime object, which prevents me from using that field as a parameter in a link to another dashboard. I want the format in the link to be YYYY-MM-DD, but redash forces it into something like
For this example the important part seems to be the casting the date (using the :: operator in this case): date_field::text, but I’m unclear if that’s just a limitation of the way I quickly created the test data. It might not be necessary to do it this way, but it seems like it ought to work.