The screenshot https://ask.libreoffice.org/uploads/asklibo/optimized/3X/1/c/1cfccbfbf9ee204b2ec79e85aaf01d4fcf881c3c_2_604x750.png shows typographic quotes (single and double) and invalid date strings.
But how he could have written that type of quotes?
Also note in the Java Exception Message: can’t grasp where the error is (?)
I’m not grasping it (?)
See here I run this very same query in the editor on my dummy DB.
Should them be ISOs in HSQLDB?
In this topic I see a lot of untagged code with typographic quotes. 3 backticks start a block of code, the next 3 backticks end a block of code. A pair of backticks can be used for "short snippets" in line with the text.
The “between two dates” filtering has not worked. I appreciate everyone’s help (especially CRDF). I found a solution that will work for me for now. I created a query that requests a two digit year entry. My History table was relatively small, so I added an additional field for the two digit year, went back through the data and added the two digit year to each line entry, and then added “:ENTER_Year” to the Criterion section of the query. When the form opens, it will ask for the two digit year and show the results for the entire year (which is acceptable for now). Then I added a button to the form with a macro to reload the form, which triggers the request for the two digit year, so that I can review another year. This isn’t exactly what I wanted, but it will work for my purposes.
Again, thanks for your help. I will explore the other options for filtering between dates after I get some of the other parts of this database rebuilt.
Of course you must pursuit a way that suits your needs in practical and simple way.
So as a résumé for reference of we treated here, enclosed an embedded dummy DB with the “method” implemented.
Just:
- The table [date | description]
- The double form.
- The routine (Macro) for the filter.
Good luck!
TestePeriodos.odb (14.7 KB)
