# Issue with ARRAYFORMULA

**URL:** <https://community.glideapps.com/t/issue-with-arrayformula/33937>\
**Category:** Ask for Help\
**Created:** [November 2, 2021, 7:24pm UTC](https://community.glideapps.com/t/issue-with-arrayformula/33937 "2021-11-02T19:24:52Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Malcolm\_Lewis](https://avatars.discourse-cdn.com/v4/letter/m/5f9b8f/32.png) [@Malcolm\_Lewis](https://community.glideapps.com/u/Malcolm_Lewis)\
**Post date:** [November 2, 2021, 7:24pm UTC](https://community.glideapps.com/t/issue-with-arrayformula/33937/1 "2021-11-02T19:24:52Z")

</div>

I posted this question in StackOverflow, but thought I’d post here too in case there is an obvious answer from Glide experts.

My goal is to show a date like **Oct 1** for posts posted in the last year, but use a longer format like **Oct 2019** for older posts.

> <https://stackoverflow.com/questions/69815829/why-does-making-this-google-sheets-formula-an-arrayformula-change-its-behavior>

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [November 2, 2021, 7:37pm UTC](https://community.glideapps.com/t/issue-with-arrayformula/33937/2 "2021-11-02T19:37:21Z")

</div>

Hola @Malcolm_Lewis

You can use the new Format Date Column in Glide and have the Format as MMM y

Look at the picture attached!

 ![Screen Shot 2021-11-02 at 12.36.29 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/b/fb43f4a6a7bc581a7964fc01791e049c21675c35.png)

---

<div class="post-metadata">

**Author:** ![Malcolm\_Lewis](https://avatars.discourse-cdn.com/v4/letter/m/5f9b8f/32.png) [@Malcolm\_Lewis](https://community.glideapps.com/u/Malcolm_Lewis)\
**Post date:** [November 2, 2021, 7:45pm UTC](https://community.glideapps.com/t/issue-with-arrayformula/33937/3 "2021-11-02T19:45:55Z")

</div>

Are they new? Love them! Opted for the Relative Option. Even managed to get **2d ago** with a template.

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [November 2, 2021, 7:46pm UTC](https://community.glideapps.com/t/issue-with-arrayformula/33937/4 "2021-11-02T19:46:47Z")

</div>

Yes!

Check your GDE.😉

---

<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:** [November 2, 2021, 10:42pm UTC](https://community.glideapps.com/t/issue-with-arrayformula/33937/5 "2021-11-02T22:42:56Z")

</div>

player0 has already replied in StackOverflow, but your issue with the arrayformula is that you used D2 instead of D2:D here.

```auto
=(IF(today()-D2 > 365

```

---

<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:** [November 3, 2021, 10:43pm UTC](https://community.glideapps.com/t/issue-with-arrayformula/33937/6 "2021-11-03T22:43:02Z")

</div>

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