I'm having this problem with a table. I imported the data, and the date column is in Unix time seconds. To convert this date column to date, I added a custom column, with this formula:
(#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, date))
Then when I go back and create a relationship with my Calendar table, the date filter doesn't work at all with this table, it just gets random dates, or similar, not really what the column has.
I am not sure if it has something to do with this, but the resulting column gets a text type by default, which I change to Date succesfully, or apparently. I have tried some other things here and there, and I even isolated the problem in a much smaller project, and it has the same exact odd results.
I've been chasing my tail the whole day, maybe someone has seen this before, please advise.
Here's a quick demo of what's going on: https://imgur.com/xF04Y41
PS: i can share the small project if that's helpful, not sure if it's safe to share a dropbox link here.
