Budibase / budibase

Low code platform for building business apps and workflows in minutes. Supports PostgreSQL, MySQL, MariaDB, MSSQL, MongoDB, Rest API, Docker, K8s, and more 🚀
https://budibase.com
Other
22.83k stars 1.58k forks source link

More than or equal to doesn't work when used on a dates in automations. Less than or equal to does work. #14836

Open ConorWebb96 opened 1 month ago

ConorWebb96 commented 1 month ago

Checklist

Hosting

Describe the bug Date data may need to change when debugging

When trying to see whether a date is more than or equal to the current date, using the helper date. It doesn't work correctly, and no rows are ever returned.

This is likely because the date helper returns a date that looks like this month day, and year. You have to write your own ISO date converter to get this to work. However, if the date is the previous day, e.g., not a full 24 hours behind, it will still return the rows.

To Reproduce Steps to reproduce the behavior:

  1. Import attached app
  2. Navigate to the automations tab and test run the automation.
  3. See that no results are return
  4. Delete the equals or greater than filter
  5. Run again see it works with the less than one
  6. Re-add the greater than or equals to filter against the To_date again the {{ date }}
  7. Run the automation and see error

Expected behavior The screenshots below show the setup filters. They are about 9/10 days into the future of today's date. I'd expect the rows to appear in the output area during a test. Instead, it shows an empty array with no rows.

Screenshots

Screenshot 2024-10-21 at 08 35 00 Screenshot 2024-10-21 at 08 35 52

App Export date filtering in automation issue

linear[bot] commented 1 month ago

BUDI-8765 More than or equal to doesn't work when used on a dates in automations. Less than or equal to does work.

phifogg commented 1 month ago

Not sure this is the same as #14869 as the more than filter worked for me.