# Contar fechas

**URL:** <https://community.glideapps.com/t/contar-fechas/73698>\
**Category:** Ask for Help\
**Created:** [May 27, 2024, 7:01pm UTC](https://community.glideapps.com/t/contar-fechas/73698 "2024-05-27T19:01:53Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jose\_carlos\_Del\_Toro](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jose_carlos_del_toro/32/72963_2.png) [@Jose\_carlos\_Del\_Toro](https://community.glideapps.com/u/Jose_carlos_Del_Toro)\
**Post date:** [May 27, 2024, 7:01pm UTC](https://community.glideapps.com/t/contar-fechas/73698/1 "2024-05-27T19:01:53Z")

</div>

Hola , tengo una columna donde pongo datos de fechas de cuando se registra una reservacion , mi duda es como hago para contar las fechas por dia es decir cuantas reservaciones tengo para cada dia que las cuente por dia dependiendo del dia en el que estemos.

---

<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:** [May 27, 2024, 9:48pm UTC](https://community.glideapps.com/t/contar-fechas/73698/2 "2024-05-27T21:48:05Z")

</div>

A Relation linking the dates together could work, followed by a Rollup to count the number of items in the relation.

However things get tricky if you have underlying times that differ, even if it’s the same day. In that case, I recommend first creating a math column to convert the date into a number that makes it easier to build your relation.

Here is what you would place in a Math column.

```auto
Year(date)*10^4 +
Month(date)*10^2 +
Day(date)

```

---

<div class="post-metadata">

**Author:** ![Jose\_carlos\_Del\_Toro](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jose_carlos_del_toro/32/72963_2.png) [@Jose\_carlos\_Del\_Toro](https://community.glideapps.com/u/Jose_carlos_Del_Toro)\
**Post date:** [September 20, 2024, 8:07pm UTC](https://community.glideapps.com/t/contar-fechas/73698/3 "2024-09-20T20:07:59Z")

</div>

tengo esto ahora que sigue?

 ![Captura de pantalla 2024-09-20 a la(s) 2.01.35 p.m.](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/7/c7e4b1884cdc7a0060b1f51a985c00e61b6d5472.png)

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [September 21, 2024, 12:27am UTC](https://community.glideapps.com/t/contar-fechas/73698/4 "2024-09-21T00:27:06Z")

</div>

If you have that on both sides, the next step is creating a relation using them, and then use a rollup to count the number of matching records.