# Date difference format issues

**URL:** <https://community.glideapps.com/t/date-difference-format-issues/56231>\
**Category:** Ask for Help\
**Created:** [January 2, 2023, 11:49am UTC](https://community.glideapps.com/t/date-difference-format-issues/56231 "2023-01-02T11:49:43Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![FV.io](https://avatars.discourse-cdn.com/v4/letter/f/49beb7/32.png) [@FV.io](https://community.glideapps.com/u/FV.io)\
**Post date:** [January 2, 2023, 11:49am UTC](https://community.glideapps.com/t/date-difference-format-issues/56231/1 "2023-01-02T11:49:43Z")

</div>

I’m trying to count how many days I have between today and a sleeted start day.

I’ve followed all guides etc., which works like it should.

But,

When I put it into my formula, the format on “days” give me a lot of decimals.  
I just want to have clean number, without decimals.

Have been trying 100’s of workarounds, without any luck

Can anyone help me out?

Please check attached:

 ![Skærmbillede 2023-01-02 kl. 12.46.13](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/b/0bbb07c1b0b1d6879857526c849cdd19be2872bb.jpeg)  
 ![Skærmbillede 2023-01-02 kl. 12.46.25](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/9/79f45f23a8dc933e3dc8f33e0345d337140a7e87.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:** [January 2, 2023, 12:01pm UTC](https://community.glideapps.com/t/date-difference-format-issues/56231/2 "2023-01-02T12:01:01Z")

</div>

The simplest way to count the number of days between two dates is with a Math column:

```auto
Trunc(End - Start)

```

 ![Screen Shot 2023-01-02 at 8.00.22 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/5/e599e960f593215583850cce8cdb92dcc9864ab7.jpeg)

Actually, I just noticed that you’re calculating the number of days between the current date and some date in the past, so you could use the special “Now” value in the math formula. eg:

```auto
Trunc(Now - Start)

```

 ![Screen Shot 2023-01-02 at 8.09.46 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/b/fbd1c9d1ac2736fc0d193bb41bf13e520d54aad5.jpeg)

---

<div class="post-metadata">

**Author:** ![FV.io](https://avatars.discourse-cdn.com/v4/letter/f/49beb7/32.png) [@FV.io](https://community.glideapps.com/u/FV.io)\
**Post date:** [January 2, 2023, 12:11pm UTC](https://community.glideapps.com/t/date-difference-format-issues/56231/3 "2023-01-02T12:11:46Z")

</div>

You’re always on the spot, with great solutions!

Thanks a lot!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [January 3, 2023, 12:12pm UTC](https://community.glideapps.com/t/date-difference-format-issues/56231/4 "2023-01-03T12:12:03Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.