I'm trying to run the datediff function against two dates but it's giving me a huge number.
I have a date parameter of 1/20/13. I wanted to find out how many days between that and TODAY(). I used DATEDIFF('day',[DAY1],TODAY())
That gave me an answer of 2,685 days. What am I doing wrong?
You've probably dropped this expression into your viz and we are doing a SUM on the output - so (~148 days * each and every record in your dataset). Wrap it in MIN().