4 Replies Latest reply: Jul 18, 2014 2:46 AM by Sunil Chauhan

# Date Difference

Hi

I have a scenario , where my i have to find the ddifference between the STATEMENT DATE , for NICK NAME and the condition is

Period Type = 'Year End'

Please find  the attached excel of sample data

• ###### Re: Date Difference

It will be as

if(Period Type = 'Year End',Interval(STATEMENT DATE-STATEMENT DATE2,'dd') as DifferenceTime

• ###### Re: Date Difference

If are you going to showcase the data in table format?, then take a pivot table...

Dimension : Nick Name

Expression: Max({<Period Type ={'Year End'}>STMT_DT)-Min({<Period Type ={'Year End'}>STMT_DT)

• ###### Re: Date Difference

Hi,

Try Interval() like this

=Interval(YearEnd([STATEMENT DATE]) - [STATEMENT DATE], 'DD') for getting the difference between the STATEMENT DATE AND Year end, if you want current year end then use below expression

=Interval(YearEnd(Today()) - [STATEMENT DATE], 'DD')

Regards,

Jagan.

• ###### Re: Date Difference

which two date you want to make difference

if(Period Type = 'Year End',Interval(DATEfeidl1-Datefield2,'dd')