4 Replies Latest reply: Jan 14, 2014 6:38 AM by Clever Anjos RSS

    date difference for same days should return 1

      Hi,

           I have 2 dates - start date and end date. If start date = end date I should get the date difference as 1. If start date is today and end date is tomm. then the date difference should be 2. How do I get this.

      I tried with interval and added 1 to it...does not work when using aggregate functions like sum etc.

       

      Thanks

      Lax