Can't join 2 datasets using date columns

Hello team

I have a very annoying issue when I’m joining my sales data with my date data (so that I can return the order year, week, month, etc.). Both the order_day column on my sales data and calendar_date column on my dates data are formatted as date and these are the only 2 columns that I’m joining. However, when I set to inner join, nothing comes up in the review and only several entries are imported when I actually publish it

Does anyone know what might have caused this?

Make sure the date formats of the two different datasets match.

For example one might be dd/MM/yyyy while another is MM/dd/yyyy


Hi @luvis1189. We hope the response from @todd.hoffman helped you. Let us know if this is resolved. And if it is, please help the community by marking the answer as a “Solution”. Many thanks.

1 Like

Hello, thanks for your response. I did check and they are the same format. Then I found out an interesting thing that it’s because of the way I write my query. If on my datasets, I use date(date column) then they join perfectly, but if I do date column :: date (which is the same thing on Redshift), it doesn’t work lol. So mysterious