8 Replies Latest reply: Oct 6, 2016 6:14 AM by Pooja Singh

# Difference between two dates

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

• ###### Re: Difference between two dates

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

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

• ###### Re: Difference between two dates

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

• ###### Re: Difference between two dates

Thankyou Maxgro ,it worked.

• ###### Re: Difference between two dates

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

• ###### Re: Difference between two dates

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,