Date Difference

[#1]

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

[sujeetsingh]

It will be as

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

[PradeepReddy]

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)

[jagan]

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.

[SunilChauhan]

which two date you want to make difference

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