4 Replies Latest reply: Sep 3, 2014 11:08 AM by Daniel Degollado RSS

    dates shows numbers and not number of days

      Hi,

       

      I have these date fields:

      Date(ISSUE_DATE, 'DD/MM/YYYY')AS ISSUE_DATE1,

           Date(CLOSED_DATE, 'DD/MM/YYYY')AS CLOSED_DATE1

       

      and if i want to calculate the date with close date and issuedate i do this

      closed_date - issue_date as daysBetweenDates

       

      then i get a list with all numbers like this:

       

      1,2323232

      4,123123123123

      3,241421414

       

       

      how can i fix this, if i use this:

      Interval(closed_date -issue_date ,'d') as daysBetweenDates

      then it will work but if i make table to select all days from 30 till 40 days then the filter wont work..

      Can anyone help me.