# BUG | November is not showing in GLIDE data editor

**URL:** <https://community.glideapps.com/t/bug-november-is-not-showing-in-glide-data-editor/69121>\
**Category:** Report a Bug\
**Created:** [December 30, 2023, 9:29pm UTC](https://community.glideapps.com/t/bug-november-is-not-showing-in-glide-data-editor/69121 "2023-12-30T21:29:14Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bunyod](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bunyod/32/68110_2.png) [@Bunyod](https://community.glideapps.com/u/Bunyod)\
**Post date:** [December 30, 2023, 9:29pm UTC](https://community.glideapps.com/t/bug-november-is-not-showing-in-glide-data-editor/69121/1 "2023-12-30T21:29:14Z")

</div>

Is it BUG or my bad?

Does anyone has this problem?

---

<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:** [December 30, 2023, 9:51pm UTC](https://community.glideapps.com/t/bug-november-is-not-showing-in-glide-data-editor/69121/2 "2023-12-30T21:51:08Z")

</div>

There isn’t 31 days in November. It’s not a valid date.

---

<div class="post-metadata">

**Author:** ![Bunyod](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bunyod/32/68110_2.png) [@Bunyod](https://community.glideapps.com/u/Bunyod)\
**Post date:** [December 30, 2023, 9:55pm UTC](https://community.glideapps.com/t/bug-november-is-not-showing-in-glide-data-editor/69121/3 "2023-12-30T21:55:04Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/c/dc990cdbe350ee8d5924a12904c749371c140223.png)  
Hey Jeff Thank you!

I thought this formula works correctly.

I’m getting -1 month from now with Excel formula.

How can I avoid this kinda problems?

---

<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:** [December 30, 2023, 10:02pm UTC](https://community.glideapps.com/t/bug-november-is-not-showing-in-glide-data-editor/69121/4 "2023-12-30T22:02:26Z")

</div>

Your video shows you manually entering a date. How does that apply to the Excel formula?

I don’t use Excel Formulas. I tend to use the Math column when dealing with dates. If I want to find the last day of the previous month I would use something like this in a math column and replace ‘Now’ with Now.

```auto
Now-Day(Now)

```

---

<div class="post-metadata">

**Author:** ![Bunyod](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bunyod/32/68110_2.png) [@Bunyod](https://community.glideapps.com/u/Bunyod)\
**Post date:** [December 30, 2023, 10:10pm UTC](https://community.glideapps.com/t/bug-november-is-not-showing-in-glide-data-editor/69121/5 "2023-12-30T22:10:23Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/1/a1e81bc00873dd23a991e922cd2f66f501cd6653.png)

Worked )

---

<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 6, 2024, 10:11pm UTC](https://community.glideapps.com/t/bug-november-is-not-showing-in-glide-data-editor/69121/6 "2024-01-06T22:11:04Z")

</div>

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