# Issue with filter

**URL:** <https://community.glideapps.com/t/issue-with-filter/66561>\
**Category:** Ask for Help\
**Created:** [September 27, 2023, 12:00pm UTC](https://community.glideapps.com/t/issue-with-filter/66561 "2023-09-27T12:00:32Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ace1](https://avatars.discourse-cdn.com/v4/letter/a/a88e4f/32.png) [@Ace1](https://community.glideapps.com/u/Ace1)\
**Post date:** [September 27, 2023, 12:00pm UTC](https://community.glideapps.com/t/issue-with-filter/66561/1 "2023-09-27T12:00:32Z")

</div>

I am currently testing out a filter feature for my app which works perfectly fine in the preview. However, When i test it on my phone it seems to come up with the dates rather than months.

Glide Builder - Preview  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/8/484665938667aa9b80218491ecf9702c83abb5a8.png)

iPhone Published view

 ![MicrosoftTeams-image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/2/f2e1088d70bd9d8a16f91b8cae57d08d5b7a1f65.jpeg)

The date is set to long version which provides the month and then i use extract matching text collum which takes anything up to the whitespace ‘(\w+)’  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/e/eed9f7568eece3b08fd8307591c70dfaacbb1f1f.png)

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/4/849f21eebae9c06a58d9444857ffe47f03057678.png)

Any help is much appreciated 🙂

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [September 27, 2023, 12:09pm UTC](https://community.glideapps.com/t/issue-with-filter/66561/2 "2023-09-27T12:09:13Z")

</div>

This will be because the date format on your phone is different to the date format in your browser.

You need to use a different method to determine the month name. Here is what I do:

- Create a column in a table somewhere that lists the month names, from Jan to Dec, one per row.
- Use a Math column to extract the Month Index number from the Date: `Month(Date)-1`
- Use a Single Value column to fetch the Month name - taking Month Index from start, and targeting the column with your Month names

This is a reliable method that will work on all devices, regardless of device/browser date formatting.

---

<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:** [October 4, 2023, 12:09pm UTC](https://community.glideapps.com/t/issue-with-filter/66561/3 "2023-10-04T12:09:37Z")

</div>

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