Interval days between dates

[Shi]

Hi everyone!

I have two tables with two different date format :

Start Date 10-May-2015 

Finish Date 2017-03-15

I should calculate difference between these two dates in days. I tried to change the format with date#..but still doesn't work. How I should do? Thanks to everyone

[dplr-rn]

share your expression how you are doing this.

typically this is how typically date conversion is done

Date(Date#('2017-03-15','YYYY-MM-DD'),'DD-MM-YYYY')

[Kushal_Chawda]

date# should work as long as you are applying correct format to it. You need to apply the same format as data currently holds. So try using below to find difference of days

date#([Finish Date],'YYYY-MM-DD') - date#([Start Date],'DD-MMM-YYYY')

[Shi]

It worked! thanks a lot