I may have discovered a bug when it comes to filtering on a field which is date only and using is on or after.
These are my several records:
Now ive created a trigger on create of another record:
I’ve trimmed the JSON Payload to focus on the value Date of Transaction
"Record Reference": 180,
"Date of Transaction": "2025-11-20",
"Transaction Recurring": [],
"Created by Automation?": false,
"Automation Processed On": null,
"Reporting - By Fixed Month": [],
"Reporting - By Payslip Month": []
}
]
This is 20th of November 2025. Now when I use this filtering
UTC?2025-11-20?exact_date I for whatever reason get the record after what it should…
Correct should have been 109 but got 110 instead?
[
{
“id”: 110,
“Name”: “28th Nov 2025 – 22nd Dec 2025”,
“Year”: “2025”,
“order”: “11.00000000000000000000”,
“End Date”: “2025-12-22”,
“Start Date”: “2025-11-28”,
“Transactions”: [
{
“id”: 201,
“order”: “2.00000000000000000000”,
“value”: “Expense - Family Support - €50.00 - 11 - 2025”
}
],
“In (Income) - Sum”: “0.00”,
“Out (Expense) - Sum”: “50.00”,
“Other (Expense) - Sum”: “0.00”,
“Salary (Income) - Sum”: “0.00”,
“Health (Expense) - Sum”: “0.00”,
“Number of Transactions”: “1”,
“Shopping (Expense) - Sum”: “0.00”,
“Transport (Expense) - Sum”: “0.00”,
“Family Support (Income) - Sum”: “50.00”,
“Food & Dining (Expense) - Sum”: “0.00”,
“Personal Care (Expense) - Sum”: “0.00”,
“Subscriptions (Expense) - Sum”: “0.00”,
“Gifts & Events (Expense) - Sum”: “0.00”,
“Fines & Penalties (Expense) - Sum”: “0.00”,
“Holiday & Leisure (Expense) - Sum”: “0.00”,
“Grants / Government (Income) - Sum”: “0.00”,
“Housing & Utilities (Expense) - Sum”: “0.00”,
“Obligatory Payments (Expense) - Sum”: “0.00”,
“Personal Investments (Expense) - Sum”: “0.00”
}
]
Additionally on further troubleshooting even doing a simile filter as the below does not work, is there something obvious I am missing?
Today Is at the time of writing.
