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 |
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
Hi,
I didn't exactly understand your requirement but below may help you,
Statement Date
31/12/2000 |
31/12/2003 |
31/12/2001 |
31/12/2005 |
Missing Year
2002
2004
Convert Missing Year in date format "Date(Date#([Missing Year], 'YYYY')) as Missing Year Date" and
If([Missing Year Date]-[Statement Date]>=730, Values)
Thanks
Hi Senthil,
Find the attached Excel file and QVW file.
I hope it addresses your problem.