6 Replies Latest reply: Apr 3, 2016 7:57 AM by rgv rand RSS

    how to subtract date and get number of days?

    gaurav gopale

      hi

      i have a table in which i have register date and verified date

       

      customer_id register_dateverified_date
      101/01/201610/01/2016
      220/01/201625/01/2106

       

      in want to subtract verified_date - register_date and add a column no_of_days

       

       

       

       

      thanks in advance