4 Replies Latest reply: Jun 14, 2017 11:18 AM by Sunny Talwar RSS

    Date # working.

    SUPRIYA DORNALA

      Hello Everyone,

       

      I have q query with the date# function

       

      DATE_1 = 20150904

      DATE_2 = 20160711

      Date#(DATE_1,'YYYYMMDD')-Date#(DATE_2,'YYYYMMDD') = output value is shown as -329 .

      But when we do it manually :20150904 – 20160711           = -9807 .

      Can any once please tell how -329 is coming.


      Thanks in Advance!


      Regards,

      Supriya Dornala.