topic Re: Interval days between dates in App Development

Interval days between dates

Shi — Fri, 24 Jul 2020 16:32:41 GMT

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

Re: Interval days between dates

dplr-rn — Fri, 24 Jul 2020 17:01:40 GMT

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')

Re: Interval days between dates

Kushal_Chawda — Fri, 24 Jul 2020 21:30:13 GMT

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')

Re: Interval days between dates

Shi — Sat, 25 Jul 2020 10:43:36 GMT

It worked! thanks a lot