What is the easiest way to calculate the difference between two dates like DATEDIFF() in Tableau?
Or
How can I check if a date is in a range of two dates?
As there is no build in function for that I need to implement my own logic like:
if(year([Year1]) - year([year2] > 0 AND month([month1]) - month([month2]) > 0 AND day([day1]) - day([day2]), “TRUE”, “FALSE”)
^ this needs a lot of effort and is not easy to maintain…
edit: I just noticed is that simple subtraction of two dates works!