1 Reply Latest reply: Jul 1, 2014 6:07 AM by Gysbert Wassenaar RSS

    Date Difference

      Hi All

       

      Please find the attaced excel for data .

      My Requirement is  - I have to check for the Statement Date and Period Type.

       

      In the excel , we have to check the Statement Date ,

      31/12/2000
      31/12/2003
      31/12/2001
      31/12/2005

       

      My Period Type should be 'Year End'

      Here the Year 2002, 2004  is missing . and i should similarly find the years missing and if the date difference between the missed year is >= 730 days , i should display the values..

       

      How it can be achieved?

       

      Thanks