1 Reply Latest reply on Jun 17, 2013 4:37 AM by Russell Christopher

    DATEDIFF giving me a HUGE number...

    michael.wu

      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?