# Datetime action variable cannot be used for filetering in a read that uses read from other

**URL:** <https://community.appfarm.io/t/datetime-action-variable-cannot-be-used-for-filetering-in-a-read-that-uses-read-from-other/2407>\
**Category:** Bug reports\
**Created:** [August 4, 2026, 12:21pm UTC](https://community.appfarm.io/t/datetime-action-variable-cannot-be-used-for-filetering-in-a-read-that-uses-read-from-other/2407 "2026-08-04T12:21:30Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![daniel](https://dub1.discourse-cdn.com/flex013/user_avatar/community.appfarm.io/daniel/32/2882_2.png) [@daniel](https://community.appfarm.io/u/daniel)\
**Post date:** [August 4, 2026, 12:21pm UTC](https://community.appfarm.io/t/datetime-action-variable-cannot-be-used-for-filetering-in-a-read-that-uses-read-from-other/2407/1 "2026-08-04T12:21:30Z")

</div>

I have an action variable of type date time. It does have a value. When i try to use it in a filter on a read action node that uses read from other, this raises an exception.

The type of comparison, does not matter. I tried smaller than, equals and not equals.

Using the same comparison in an if statement or a read that reads form the database works fine.

Using a different datetime datasource for the comparison also works fine

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/appfarm/original/2X/e/e285153410efd467b180cb02a6e9542864aeb734.png)

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/appfarm/original/2X/c/cc2bee7483209099dd813c8d4525f9db8834d9c7.png)

---

<div class="post-metadata">

**Author:** ![Olav](https://dub1.discourse-cdn.com/flex013/user_avatar/community.appfarm.io/olav/32/63_2.png) [@Olav](https://community.appfarm.io/u/Olav)\
**Post date:** [August 5, 2026, 7:28am UTC](https://community.appfarm.io/t/datetime-action-variable-cannot-be-used-for-filetering-in-a-read-that-uses-read-from-other/2407/2 "2026-08-05T07:28:11Z")

</div>

Hi, and thank you for reporting this!

I was not immediately able to reproduce this bug, could you share some more details about your setup? How are the data sources that you read to and from set up? How is the action logic set up?

---

<div class="post-metadata">

**Author:** ![daniel](https://dub1.discourse-cdn.com/flex013/user_avatar/community.appfarm.io/daniel/32/2882_2.png) [@daniel](https://community.appfarm.io/u/daniel)\
**Post date:** [August 5, 2026, 10:51am UTC](https://community.appfarm.io/t/datetime-action-variable-cannot-be-used-for-filetering-in-a-read-that-uses-read-from-other/2407/3 "2026-08-05T10:51:39Z")

</div>

I read from a many runtime datasource to a one runtime datasource. The logic in the action is complex, and I changed it slightly to get around this issue. The one thing I believe may be relevant in the action logic is a function that was used to set the datetime value in the action variable.

Let me know if you still have trouble reproducing it. I don’t have access to the set up that originally cause the issue, but I may be able to reproduce it in a standalone app.

 ![Screenshot 2026-08-05 at 12.39.47](https://europe1.discourse-cdn.com/flex013/uploads/appfarm/original/2X/5/53405762d7a9d8258fe20022af8a267c4ec69d74.png)

 ![Screenshot 2026-08-05 at 12.39.55](https://europe1.discourse-cdn.com/flex013/uploads/appfarm/original/2X/e/eb6fea639dcb41581af74702df370202fa935718.png)

 ![Screenshot 2026-08-05 at 12.48.36](https://europe1.discourse-cdn.com/flex013/uploads/appfarm/original/2X/0/07f9b809e1dcb67cb7873c3ee9ce494f4855c543.png)

---

<div class="post-metadata">

**Author:** ![Olav](https://dub1.discourse-cdn.com/flex013/user_avatar/community.appfarm.io/olav/32/63_2.png) [@Olav](https://community.appfarm.io/u/Olav)\
**Post date:** [August 5, 2026, 12:24pm UTC](https://community.appfarm.io/t/datetime-action-variable-cannot-be-used-for-filetering-in-a-read-that-uses-read-from-other/2407/4 "2026-08-05T12:24:01Z")

</div>

Thank you for providing further details!  
I’m still not able to reproduce this on my end, so if you have a reproducible case that you could give me access to, that would be very helpful.

---

<div class="post-metadata">

**Author:** ![Lavrans](https://dub1.discourse-cdn.com/flex013/user_avatar/community.appfarm.io/lavrans/32/1460_2.png) [@Lavrans](https://community.appfarm.io/u/Lavrans)\
**Post date:** [August 6, 2026, 6:53pm UTC](https://community.appfarm.io/t/datetime-action-variable-cannot-be-used-for-filetering-in-a-read-that-uses-read-from-other/2407/5 "2026-08-06T18:53:44Z")

</div>

I had a similar issue where an Aggregate Data node would fail when filtered on an Action Variable. It worked when I swapped it out for Action Input value instead