# Difference of End - Start Dates Differ in 2 Column

**URL:** <https://community.glideapps.com/t/difference-of-end-start-dates-differ-in-2-column/49018>\
**Category:** Ask for Help\
**Created:** [September 10, 2022, 8:01am UTC](https://community.glideapps.com/t/difference-of-end-start-dates-differ-in-2-column/49018 "2022-09-10T08:01:12Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)\
**Post date:** [September 10, 2022, 8:01am UTC](https://community.glideapps.com/t/difference-of-end-start-dates-differ-in-2-column/49018/1 "2022-09-10T08:01:12Z")

</div>

Dear Community,

We noticed there are differences in the computed values when we deduct 2 dates column (similar columns) for both EC Calc & cal\_No.of Years.

 ![EC Calc](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/d/6d25830154493f8137df67cd700e928d2c260e5e.jpeg)

Notice the above EC Calc, the value shown is X years. The value in cal\_No\_EC\_Years is in decimal.

 ![EC Calc](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/d/6d25830154493f8137df67cd700e928d2c260e5e.jpeg)

Both the start and end dates are Date Only - Medium.

 ![no. years](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/c/fc939ce1afb4c5bba07099dfbaed662ddea6758c.jpeg)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [September 10, 2022, 8:46am UTC](https://community.glideapps.com/t/difference-of-end-start-dates-differ-in-2-column/49018/2 "2022-09-10T08:46:42Z")

</div>

To subtract one date from another and get a result in decimal years, you need to use the following:

`Round(End-Start)/365`

 ![Screen Shot 2022-09-10 at 4.47.37 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/1/7135307dff191f8889d95047c286e31b5ea90fcf.png)

---

<div class="post-metadata">

**Author:** ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)\
**Post date:** [September 10, 2022, 8:50am UTC](https://community.glideapps.com/t/difference-of-end-start-dates-differ-in-2-column/49018/3 "2022-09-10T08:50:07Z")

</div>

Got it…

But in my screenshot above, Notice the ROund wasn’t in both the screenshots, and yet the first column has a “years”

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [September 10, 2022, 9:05am UTC](https://community.glideapps.com/t/difference-of-end-start-dates-differ-in-2-column/49018/4 "2022-09-10T09:05:36Z")

</div>

Isn’t that just the display units that you’ve set in the math column?

---

<div class="post-metadata">

**Author:** ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)\
**Post date:** [September 10, 2022, 9:19am UTC](https://community.glideapps.com/t/difference-of-end-start-dates-differ-in-2-column/49018/5 "2022-09-10T09:19:16Z")

</div>

The left column has a “years” showing.

 ![no. years](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/c/fc939ce1afb4c5bba07099dfbaed662ddea6758c.jpeg)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [September 10, 2022, 9:54am UTC](https://community.glideapps.com/t/difference-of-end-start-dates-differ-in-2-column/49018/6 "2022-09-10T09:54:38Z")

</div>

Yes, and I assume that’s because it’s what you have set as the display units?

 ![Screen Shot 2022-09-10 at 5.52.55 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/9/792991e5cae13e1423b00bc07760dee8e14e743d.png)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [September 10, 2022, 11:12am UTC](https://community.glideapps.com/t/difference-of-end-start-dates-differ-in-2-column/49018/7 "2022-09-10T11:12:36Z")

</div>

You showed the EC\_Calc configuration twice. How did you set up cal\_No\_EC\_Years?