Difference between two dates

[Karahs]

hello everyone,

I need to findout difference between Completed and alloted date on based of selection of empid.

Status           CreatedDate

Completed     9/2/2016

Alloted           9/23/2016

Thanks

[lakshmikandh]

Interval(if(match(Status,'Completed'),CreatedDate)-

if(match(Status,'Alloted'),CreatedDate),'d')

[Karahs]

What is that 'd' for?

[lakshmikandh]

Days

https://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/Scripting/FormattingFunctions/Interval....

[maxgro · Accepted solution]

maybe (it depends on your selection)

max({$<Status={'Completed'}>} CreatedDate) - max({$<Status={'Alloted'}>} CreatedDate)

if you have dates, you can use math to find the difference

[Karahs]

Doesnt work

[nagarjuna_kotha]

May be like this :

if Every employee has single date use below one :

Only({<Status={'Alloted'}>}CreatedDate) - Only({<Status={'Completed'}>}CreatedDate)

and

if Every employee has multiple dates use below one :

Max({<Status={'Alloted'}>}CreatedDate) - Max({<Status={'Completed'}>}CreatedDate)

I hope this may helps

-Nagarjun

[#8]

Try interval(date(Completed,'DD-MM-YYYY')-date(Allotted,'DD-MM-YYYY'),'d').

Here I am assuming that you have two (Completed and Allotted) different fields and you are looking for difference in these dates.

Thanks,

[Karahs]

Thankyou Maxgro ,it worked.