# Can't Load Values from Month and Year formula on iOS

**URL:** <https://community.glideapps.com/t/cant-load-values-from-month-and-year-formula-on-ios/16998>\
**Category:** Report a Bug\
**Created:** [October 10, 2020, 4:49pm UTC](https://community.glideapps.com/t/cant-load-values-from-month-and-year-formula-on-ios/16998 "2020-10-10T16:49:01Z")\
**Posts on this page:** 19\
**Page:** 2

<div class="post-metadata">

**Author:** ![Antonino\_Nolasco](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/antonino_nolasco/32/80601_2.png) [@Antonino\_Nolasco](https://community.glideapps.com/u/Antonino_Nolasco)\
**Post date:** [October 12, 2020, 6:37am UTC](https://community.glideapps.com/t/cant-load-values-from-month-and-year-formula-on-ios/16998/21 "2020-10-12T06:37:40Z")

</div>

I tried to open app on Windows 10 with Chrome and it works. Guys I need help to solve this problem, my company uses iPhone and month formula values are empty on iOS. Helpppppop pleaseeeeee

---

<div class="post-metadata">

**Author:** ![wjcv06](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wjcv06/32/12747_2.png) [@wjcv06](https://community.glideapps.com/u/wjcv06)\
**Post date:** [October 12, 2020, 6:40am UTC](https://community.glideapps.com/t/cant-load-values-from-month-and-year-formula-on-ios/16998/22 "2020-10-12T06:40:37Z")

</div>

There is a bug with math columns

---

<div class="post-metadata">

**Author:** ![Antonino\_Nolasco](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/antonino_nolasco/32/80601_2.png) [@Antonino\_Nolasco](https://community.glideapps.com/u/Antonino_Nolasco)\
**Post date:** [October 12, 2020, 4:20pm UTC](https://community.glideapps.com/t/cant-load-values-from-month-and-year-formula-on-ios/16998/23 "2020-10-12T16:20:07Z")

</div>

When will they fix it? @david @Mark

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [October 13, 2020, 1:59pm UTC](https://community.glideapps.com/t/cant-load-values-from-month-and-year-formula-on-ios/16998/24 "2020-10-13T13:59:51Z")

</div>

This should be fixed by tomorrow.

---

<div class="post-metadata">

**Author:** ![darder](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darder/32/12788_2.png) [@darder](https://community.glideapps.com/u/darder)\
**Post date:** [October 13, 2020, 2:29pm UTC](https://community.glideapps.com/t/cant-load-values-from-month-and-year-formula-on-ios/16998/25 "2020-10-13T14:29:36Z")

</div>

> [@spiral\_calendar Month, Day, and Year Math Functions](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/29):
>
> This will be fixed on Thursday.

This issue was reported last week. @Mark is aware of it.

---

<div class="post-metadata">

**Author:** ![Antonino\_Nolasco](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/antonino_nolasco/32/80601_2.png) [@Antonino\_Nolasco](https://community.glideapps.com/u/Antonino_Nolasco)\
**Post date:** [October 13, 2020, 2:32pm UTC](https://community.glideapps.com/t/cant-load-values-from-month-and-year-formula-on-ios/16998/26 "2020-10-13T14:32:54Z")

</div>

But from table I can see the values and from Android e desktop app it works, it doesn’t work only on iOS. This issue I didn’t read there.

---

<div class="post-metadata">

**Author:** ![Antonino\_Nolasco](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/antonino_nolasco/32/80601_2.png) [@Antonino\_Nolasco](https://community.glideapps.com/u/Antonino_Nolasco)\
**Post date:** [October 15, 2020, 9:00am UTC](https://community.glideapps.com/t/cant-load-values-from-month-and-year-formula-on-ios/16998/27 "2020-10-15T09:00:13Z")

</div>

Guys I can’t wait anymore. I read that a bug relating to day/month/year has been fixed. But have you at least tried if what you fixed works? You just need to create a math column with month(x) function with x = date column and add it on details view, it will be not visible on ios device. This not works only using Google Sheet, with Glide Table it works. And with “now” it works too.

---

<div class="post-metadata">

**Author:** ![Antonino\_Nolasco](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/antonino_nolasco/32/80601_2.png) [@Antonino\_Nolasco](https://community.glideapps.com/u/Antonino_Nolasco)\
**Post date:** [October 15, 2020, 9:08am UTC](https://community.glideapps.com/t/cant-load-values-from-month-and-year-formula-on-ios/16998/28 "2020-10-15T09:08:03Z")

</div>

Others videos:

---

<div class="post-metadata">

**Author:** ![darder](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darder/32/12788_2.png) [@darder](https://community.glideapps.com/u/darder)\
**Post date:** [October 15, 2020, 12:11pm UTC](https://community.glideapps.com/t/cant-load-values-from-month-and-year-formula-on-ios/16998/29 "2020-10-15T12:11:25Z")

</div>

HI @Mark!

Glide Twitter says that the date math features is available …

 ![Captura de pantalla 2020-10-15 a las 14.07.03](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/9492f24ff03bbee77e558e5586d8dc082db07709.png)

But I’m already have the issue…

 ![Captura de pantalla 2020-10-15 a las 14.03.52](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/065a63742373b82555ada1f886c466f0f078abd0.png)

Do we have to wait a little or maybe in my case the bug persist ?

Thanks

---

<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:** [October 15, 2020, 1:25pm UTC](https://community.glideapps.com/t/cant-load-values-from-month-and-year-formula-on-ios/16998/30 "2020-10-15T13:25:43Z")

</div>

Try removing the space between Month and the parenthesis.

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [October 15, 2020, 2:45pm UTC](https://community.glideapps.com/t/cant-load-values-from-month-and-year-formula-on-ios/16998/31 "2020-10-15T14:45:08Z")

</div>

This fix is rolling out later today.

---

<div class="post-metadata">

**Author:** ![Antonino\_Nolasco](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/antonino_nolasco/32/80601_2.png) [@Antonino\_Nolasco](https://community.glideapps.com/u/Antonino_Nolasco)\
**Post date:** [October 15, 2020, 2:50pm UTC](https://community.glideapps.com/t/cant-load-values-from-month-and-year-formula-on-ios/16998/32 "2020-10-15T14:50:14Z")

</div>

And about my problem @Mark ?

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [October 15, 2020, 2:57pm UTC](https://community.glideapps.com/t/cant-load-values-from-month-and-year-formula-on-ios/16998/33 "2020-10-15T14:57:30Z")

</div>

It’s probably the same root cause, so the fix should apply, too.

---

<div class="post-metadata">

**Author:** ![Antonino\_Nolasco](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/antonino_nolasco/32/80601_2.png) [@Antonino\_Nolasco](https://community.glideapps.com/u/Antonino_Nolasco)\
**Post date:** [October 15, 2020, 9:40pm UTC](https://community.glideapps.com/t/cant-load-values-from-month-and-year-formula-on-ios/16998/34 "2020-10-15T21:40:59Z")

</div>

I can finally confirm that the bug has been fixed. Thank you Glide.

---

<div class="post-metadata">

**Author:** ![darder](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darder/32/12788_2.png) [@darder](https://community.glideapps.com/u/darder)\
**Post date:** [October 15, 2020, 11:50pm UTC](https://community.glideapps.com/t/cant-load-values-from-month-and-year-formula-on-ios/16998/35 "2020-10-15T23:50:25Z")

</div>

And yep, it is fixed! Thanks!

---

<div class="post-metadata">

**Author:** ![darder](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darder/32/12788_2.png) [@darder](https://community.glideapps.com/u/darder)\
**Post date:** [October 15, 2020, 11:58pm UTC](https://community.glideapps.com/t/cant-load-values-from-month-and-year-formula-on-ios/16998/36 "2020-10-15T23:58:26Z")

</div>

It would be nice to have a complete syntax reference for math computed columns.

For example: with this formula Month (ColumnName) I get the month number.

What if I want the month name? Is it possible to get this directly or do I have to use an if then else column…

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [October 16, 2020, 12:05am UTC](https://community.glideapps.com/t/cant-load-values-from-month-and-year-formula-on-ios/16998/37 "2020-10-16T00:05:52Z")

</div>

It would be cool if, when using the Month/Day formulas, you were given the date formatting options inside the Math column builder pop-up thingy. That way, you could select short/medium/long to format the formula’s result with either 10/Oct/October, for example.

---

<div class="post-metadata">

**Author:** ![Antonino\_Nolasco](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/antonino_nolasco/32/80601_2.png) [@Antonino\_Nolasco](https://community.glideapps.com/u/Antonino_Nolasco)\
**Post date:** [October 16, 2020, 6:29am UTC](https://community.glideapps.com/t/cant-load-values-from-month-and-year-formula-on-ios/16998/38 "2020-10-16T06:29:02Z")

</div>

You can do this with If Than Else column.

---

<div class="post-metadata">

**Author:** ![darder](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darder/32/12788_2.png) [@darder](https://community.glideapps.com/u/darder)\
**Post date:** [October 16, 2020, 9:08am UTC](https://community.glideapps.com/t/cant-load-values-from-month-and-year-formula-on-ios/16998/39 "2020-10-16T09:08:53Z")

</div>

Yep!

[Previous page](https://community.glideapps.com/t/cant-load-values-from-month-and-year-formula-on-ios/16998.md?page=1)
