Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See attached qvw.