# Dates Math Error

**URL:** <https://community.glideapps.com/t/dates-math-error/58152>\
**Category:** Ask for Help\
**Created:** [February 19, 2023, 11:18am UTC](https://community.glideapps.com/t/dates-math-error/58152 "2023-02-19T11:18:29Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Killko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/killko/32/39538_2.png) [@Killko](https://community.glideapps.com/u/Killko)\
**Post date:** [February 19, 2023, 11:18am UTC](https://community.glideapps.com/t/dates-math-error/58152/1 "2023-02-19T11:18:29Z")

</div>

I’m trying to get the number of days since a given date.  
I’m using this formula : TRUNC(NOW - DATE)

Weirdly it works fine in a Glide Apps (1st image), but not in Glide Pages (2nd image)…

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/2/f22fe7814776680d0a81f832ff1dd1ea9375bafa.jpeg)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/1/b13ba9a36b360acb1a8e15dea78f06a66c51e801.jpeg)

---

<div class="post-metadata">

**Author:** ![Killko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/killko/32/39538_2.png) [@Killko](https://community.glideapps.com/u/Killko)\
**Post date:** [February 19, 2023, 11:21am UTC](https://community.glideapps.com/t/dates-math-error/58152/2 "2023-02-19T11:21:58Z")

</div>

Oups just found the problem, the Glide App works of a Google Sheet which is in american date format

---

<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:** [February 20, 2023, 11:22am UTC](https://community.glideapps.com/t/dates-math-error/58152/3 "2023-02-20T11:22:23Z")

</div>

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