I'm using both; since I'm defining the date field directly into an inline table; qlik is logically not recognizing the as date but as string..
and so, with date# I'm sort of casting the field; telling qlik to treat the field as if it was a date with a certain format; then with the date() function, I really transform each value to a real date !
But, for ur case, u're not obligated to do that if Qlik is already recognizing ur date field as date !
Is there a way to unite all this content in a single table? I know the question seems dumb, but I can't add more columns to the Inner Join IntervalMatch and if I add a Join after the Inner Join it creates a cartesian product.