Thanks for your quick response. This seems the solution for my problem but in my environment its not working when I tried to rebuild it:
- I joined a MySQL database with a Calender Excel file like you mentioned
(please note that Created = Created date and Cancelled At = Cancelled date in our database)
- I tried to inner join them with the 1 = 1 like you did in the example above but I cannot fill in a "1" on both sides. See screenshot A below, which is strange.
What might be the reason is that we are using UNIX timestamps instead of dates. And I convert the UNIX timestamps to dates in the calculated fields with the following formula:
Do you have an idea how to solve this issue?