# Problem with Data Store filter **URL:** \ **Category:** Questions\ **Tags:** filters, functions\ **Created:** [February 12, 2024, 5:04pm UTC](https://community.make.com/t/problem-with-data-store-filter/27246 "2024-02-12T17:04:14Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![ea1](https://avatars.discourse-cdn.com/v4/letter/e/aeb1de/32.png) [@ea1](https://community.make.com/u/ea1)\ **Post date:** [February 12, 2024, 5:04pm UTC](https://community.make.com/t/problem-with-data-store-filter/27246/1 "2024-02-12T17:04:14Z")
I have one scenario that creates a Data store using the following parameters [blueprint(3).json](https://community.make.com/uploads/short-url/t49zglWFPYJo44WB2f1NVpocQS8.json) (17.5 KB) ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/a/3a736614078419270877d265ca6b8c4dce17a6f3.png) it comes out to look like this: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/d/fd9eba95881b1839db606bbdd2c11992ec1a5413.png) Now, I am having an issue with the data store filters. Here is my current scenario: [blueprint(2).json](https://community.make.com/uploads/short-url/3jv6HeV50dwfnlpoo0EeWbbqGnV.json) (25.4 KB) ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/c/8ca67f10b88d844b32bada2e32128cc6396be849.png) The scenario runs on a half hourly schedule. The first module looks through a filter of “Follow-up date & time” being between 20 minutes before and after the current time. So for example if it happens at 1:00 AM, the filter should allow any values between 12:40 AM and 1:20 AM. ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/1/e/1e93b8a5cd18b3d3540eae06af537490d2a72266.png) The issue is, it is not letting them through the filter if its created automatically using a different scenario. If i manually change the date and time in the Data store, it typically works, also when i run it manually. But if i have the other scenario create a data store, and then have this scenario search through the data store, it doesnt work. Please if someone can help me with this, id be very grateful. ---
**Author:** ![sachinkadam5](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/sachinkadam5/32/25887_2.png) [@sachinkadam5](https://community.make.com/u/sachinkadam5)\ **Post date:** [February 13, 2024, 6:46am UTC](https://community.make.com/t/problem-with-data-store-filter/27246/2 "2024-02-13T06:46:13Z")
@ea1 are you getting data from your webhook in text? format ---
**Author:** ![ea1](https://avatars.discourse-cdn.com/v4/letter/e/aeb1de/32.png) [@ea1](https://community.make.com/u/ea1)\ **Post date:** [February 13, 2024, 4:25pm UTC](https://community.make.com/t/problem-with-data-store-filter/27246/3 "2024-02-13T16:25:24Z")
@sachinkadam5 I mean yes, but when i input the Fallback Match from the text parser that is only for the addHours part. The “now” part should keep it in a date format, no? Could it be that it is changing the format of the data store? how would that make sense though? The data store that creates the record does correctly store it as the correct number of hours later, but it is just not being read by the second scenario. ---
**Author:** ![alex.newpath](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/alex.newpath/32/84_2.png) [@alex.newpath](https://community.make.com/u/alex.newpath)\ **Post date:** [February 13, 2024, 6:14pm UTC](https://community.make.com/t/problem-with-data-store-filter/27246/4 "2024-02-13T18:14:49Z")
If you run the Data Store module at the start of the scenario on its own does it retrieve the expected data from the data store on its own (assuming there are records that fit the criteria?) ---
**Author:** ![ea1](https://avatars.discourse-cdn.com/v4/letter/e/aeb1de/32.png) [@ea1](https://community.make.com/u/ea1)\ **Post date:** [February 13, 2024, 7:09pm UTC](https://community.make.com/t/problem-with-data-store-filter/27246/5 "2024-02-13T19:09:58Z")
I just tried and it did let it through. But like i said previously, when i manually change the data store, it seems to work. Its only when the record is created automatically that it doesnt detect it ---
**Author:** ![alex.newpath](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/alex.newpath/32/84_2.png) [@alex.newpath](https://community.make.com/u/alex.newpath)\ **Post date:** [February 13, 2024, 7:14pm UTC](https://community.make.com/t/problem-with-data-store-filter/27246/6 "2024-02-13T19:14:50Z")
So if you run it manually with the auto created records can you confirm the records that are automatically created are actually in the range? The data is instantly saved so the only explanation is the records created are not in the range in terms of time. ---
**Author:** ![ea1](https://avatars.discourse-cdn.com/v4/letter/e/aeb1de/32.png) [@ea1](https://community.make.com/u/ea1)\ **Post date:** [February 13, 2024, 7:26pm UTC](https://community.make.com/t/problem-with-data-store-filter/27246/7 "2024-02-13T19:26:55Z")
The data is in fact in the range. I have done this before, but ill run it automatically now so i can show you ---
**Author:** ![ea1](https://avatars.discourse-cdn.com/v4/letter/e/aeb1de/32.png) [@ea1](https://community.make.com/u/ea1)\ **Post date:** [February 13, 2024, 7:34pm UTC](https://community.make.com/t/problem-with-data-store-filter/27246/8 "2024-02-13T19:34:59Z")
Ok, now its doing what it did the other night. When i run it now, it is letting it through, however, last time i thought i had figured it out, so i let it run continoulsly, and when i woke up, i realized it stopped working after the first run ---
**Author:** ![ea1](https://avatars.discourse-cdn.com/v4/letter/e/aeb1de/32.png) [@ea1](https://community.make.com/u/ea1)\ **Post date:** [February 13, 2024, 7:38pm UTC](https://community.make.com/t/problem-with-data-store-filter/27246/9 "2024-02-13T19:38:39Z")
wait nevermind, made a mistake, it did now work ---
**Author:** ![ea1](https://avatars.discourse-cdn.com/v4/letter/e/aeb1de/32.png) [@ea1](https://community.make.com/u/ea1)\ **Post date:** [February 13, 2024, 7:40pm UTC](https://community.make.com/t/problem-with-data-store-filter/27246/10 "2024-02-13T19:40:45Z")
Here is the results from the module: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/6/86e08f79ef18719e69e771351ed65490077d46cb.png) Here is the automated test data: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/b/6bda9ef6e87d0587a257ffbc182a53336dc501a0.png) You can see it did not go through the filter ---
**Author:** ![alex.newpath](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/alex.newpath/32/84_2.png) [@alex.newpath](https://community.make.com/u/alex.newpath)\ **Post date:** [February 14, 2024, 12:54pm UTC](https://community.make.com/t/problem-with-data-store-filter/27246/11 "2024-02-14T12:54:36Z")
Have you checked the time zone of the underlying data? And your time zone on your account? ---
**Author:** ![ea1](https://avatars.discourse-cdn.com/v4/letter/e/aeb1de/32.png) [@ea1](https://community.make.com/u/ea1)\ **Post date:** [February 14, 2024, 3:53pm UTC](https://community.make.com/t/problem-with-data-store-filter/27246/12 "2024-02-14T15:53:08Z")
Yes i have, both are set to my current one. And as i said, when i do it manually for the specified time, it works, its only when automatic ---
**Author:** ![Ali2](https://avatars.discourse-cdn.com/v4/letter/a/bbce88/32.png) [@Ali2](https://community.make.com/u/Ali2)\ **Post date:** [February 14, 2024, 4:13pm UTC](https://community.make.com/t/problem-with-data-store-filter/27246/13 "2024-02-14T16:13:35Z")
hey @ea1 , i have almost same issue with filter, but it is not going though filter when i use dateTime Later - operator , it worked without mistakes yet, but few days ago it started not going though filter ![Снимок экрана 2024-02-14 в 19.44.44](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/7/57c712b4ec34e8b3d454c7fbbab5562dd354bce1.jpeg) ![Снимок экрана 2024-02-14 в 19.44.51](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/c/fc9d7ca8bdfc115843042380e067c8853e178b94.jpeg) ---
**Author:** ![ea1](https://avatars.discourse-cdn.com/v4/letter/e/aeb1de/32.png) [@ea1](https://community.make.com/u/ea1)\ **Post date:** [February 14, 2024, 4:14pm UTC](https://community.make.com/t/problem-with-data-store-filter/27246/14 "2024-02-14T16:14:16Z")
This has to be a bug. I have tried legitimately everything! ---
**Author:** ![Ali2](https://avatars.discourse-cdn.com/v4/letter/a/bbce88/32.png) [@Ali2](https://community.make.com/u/Ali2)\ **Post date:** [February 14, 2024, 4:15pm UTC](https://community.make.com/t/problem-with-data-store-filter/27246/15 "2024-02-14T16:15:45Z")
yep, absolutely . it should have to be bug ---
**Author:** ![ea1](https://avatars.discourse-cdn.com/v4/letter/e/aeb1de/32.png) [@ea1](https://community.make.com/u/ea1)\ **Post date:** [February 14, 2024, 5:22pm UTC](https://community.make.com/t/problem-with-data-store-filter/27246/16 "2024-02-14T17:22:30Z")
@alex.newpath would you know who i have to contact to figure this out? ---
**Author:** ![alex.newpath](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/alex.newpath/32/84_2.png) [@alex.newpath](https://community.make.com/u/alex.newpath)\ **Post date:** [February 14, 2024, 7:27pm UTC](https://community.make.com/t/problem-with-data-store-filter/27246/17 "2024-02-14T19:27:35Z")
Make support can help you out if this is a bug. You can open a ticket under the help icon on the bottom right corner. ---
**Author:** ![Michaela-Inactive](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/michaela-inactive/32/29_2.png) [@Michaela-Inactive](https://community.make.com/u/Michaela-Inactive)\ **Post date:** [February 29, 2024, 7:57am UTC](https://community.make.com/t/problem-with-data-store-filter/27246/19 "2024-02-29T07:57:03Z")
Hello @ea1 👋 I see that you opened a ticket with us and that the support team investigated this and gave you the following advice. I’m sharing it here for the benefit of the community. ⬇ > **Make Support response:** > > Unfortunately, we were not able to reproduce this behavior on our end. We suggest that you please check your local format of the date and time. Working with date and time can be tricky so we would suggest adding the [parseDate()](https://www.make.com/en/help/functions/date---time-functions#parsedate--text--format---timezone--) and [formatDate()](https://www.make.com/en/help/functions/date---time-functions#formatdate--date--format---timezone--) functions in your filters as it is showing in your Data store make sure all the formats match and then give it a try. ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [March 14, 2024, 8:02am UTC](https://community.make.com/t/problem-with-data-store-filter/27246/20 "2024-03-14T08:02:53Z")
This topic was automatically closed because it's resolved or inactive. Please, start a new topic.