Bases: Invalid date format error (but correct result)

Help
1

Apologies if this has been asked already, but I didn’t find anything through search. I am just starting to use the new Bases feature, and have created a view that filters for the current year. I have property called “finish”, and am sorting where all of the following are true:

  • dateOnOrAfter(property.finish, “2024-01-01”)
  • dateOnOrBefore(property.finish, “2024-12-31”)

The results of the filter are working just as expected, but every time I select the view I get the following error:

Failed to evaluate a filter: Invalid date format for left side of function “dateOnOrAfter”.

I have tried other date formats and all still give the same error while at the same time also still giving the expected results.

2

Most likely this is not the date format being wrong as such or in general, but rather that the finish property is either missing from some of your files (or possibly not correct format in a few files)

3

You are correct, sir! I had not realized it, but one of my files had text in that field. Once I removed that, the error went away. Thank you!!!

4

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