If you're having trouble formatting dates (especially in Sheets), best way to get consistent format is to cast dates as a string

• SQL Server
• MySQL
• Postgres
• Snowflake

BigQuery