# Condicion que pueda relacionar un registro de mes y al ser verdadero me muestre otro mes

**URL:** <https://community.glideapps.com/t/condicion-que-pueda-relacionar-un-registro-de-mes-y-al-ser-verdadero-me-muestre-otro-mes/81074>\
**Category:** Ask for Help\
**Created:** [March 31, 2025, 2:36pm UTC](https://community.glideapps.com/t/condicion-que-pueda-relacionar-un-registro-de-mes-y-al-ser-verdadero-me-muestre-otro-mes/81074 "2025-03-31T14:36:03Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gerytel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gerytel/32/54692_2.png) [@Gerytel](https://community.glideapps.com/u/Gerytel)\
**Post date:** [March 31, 2025, 2:36pm UTC](https://community.glideapps.com/t/condicion-que-pueda-relacionar-un-registro-de-mes-y-al-ser-verdadero-me-muestre-otro-mes/81074/1 "2025-03-31T14:36:03Z")

</div>

hola,

Tengo un campo en mi tabla que me muestra de forma automatica el mes Actual, y nesecito otro campo donde me lea el mes actual y como resultado me muestre el mes anterior.

es decir: si el campo registra Mes de marzo entonces que me registre febrero.

¿hay algun componente que me permita hacerlo?

---

<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:** [April 1, 2025, 1:51am UTC](https://community.glideapps.com/t/condicion-que-pueda-relacionar-un-registro-de-mes-y-al-ser-verdadero-me-muestre-otro-mes/81074/2 "2025-04-01T01:51:08Z")

</div>

If you’re calculating the current month using a math column:

```auto
YEAR(N)*10^2+MONTH(N)

```

With N being the “Now” value, the formula gives you 202504 as today is April 1st.

You can use this to get the last month.

```auto
YEAR(N-DAY(N))*10^2+MONTH(N-DAY(N))

```

Which gives you 202503.

I’m not sure if you need to format it in a specific way, it would need some adjustments if you need it.

---

<div class="post-metadata">

**Author:** ![Gerytel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gerytel/32/54692_2.png) [@Gerytel](https://community.glideapps.com/u/Gerytel)\
**Post date:** [April 3, 2025, 9:44pm UTC](https://community.glideapps.com/t/condicion-que-pueda-relacionar-un-registro-de-mes-y-al-ser-verdadero-me-muestre-otro-mes/81074/3 "2025-04-03T21:44:42Z")

</div>

excelente,

gracias

---

<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:** [April 10, 2025, 9:45pm UTC](https://community.glideapps.com/t/condicion-que-pueda-relacionar-un-registro-de-mes-y-al-ser-verdadero-me-muestre-otro-mes/81074/4 "2025-04-10T21:45:25Z")

</div>

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