Google Sheets IMPORTDATA date format

I’m using the IMPORTDATA function but dates are not appearing correctly in the Google Sheet.

For example, in the database query a date appears as 2019-09-11 00:00, but in the Google Sheet it is 43719

Is there a way to fix this?

Welcome to the forum. This isn’t an issue with Redash. It’s your Google Sheet. Change the format of the cell to “Date” and it will display as 2019-09-11.

1 Like

Thanks, that works perfectly!