Date Difference

[#1]

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

[Anonymous]

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

[mahesh_agrawal]

Hi Senthil,

Find the attached Excel file and QVW file.

I hope it addresses your problem.