I am having trouble understanding the mechanics of the date search.
I have a field on a form who’s data source is a DATE column (this is an Oracle database).
I specified a ‘Default format’ of yyyy-MMM-dd HH:mm:ss at the table level in the Database Servers area in Servoy.
I didn’t specify any format for the field when I put it on the form.
The form is a ‘table view (locked)’ type.
When I display data the date displays correctly in the the format I specified - so far, so good.
If I place the form in find mode I can find data if I specify an exact date…
I tried… 2009-Jan-26 16:36:27 and found records.
However, I can’t figure out how to successfully specify a range of dates…
I tried… 2009-Jan-26 16:36:00…2009-Jan-26 16:36:30|yyyy-MMM-dd HH:mm:ss and it finds nothing.
I tried… 2009-Jan-26 16:36:00…2009-Jan-26 16:36:30 and it finds nothing.
I also can’t figure out how to search and ignore the time…
I tried… #2009-Jan-26|yyyy-MMM-dd and it finds nothing.
I’m also looking for a way to do a ‘greater than this date’ query and have had no success…
I tried… >2009-Jan-26 16:36:00 and it finds nothing.
I read over the Servoy Help on this and thought I understood how to do date ranges, etc - but I’m missing something.
Anyone have any comments on this?
Thanks in advance
We have the exact same problems with date search here, using a Sybase SQL Anywhere database. I even can’t search for a date like 24.02.2009 (the date format we use here in Switzerland), searching with 24.02.2009|dd.MM.yyyy doesn’t help either. Tried already many different ways (I remember it used to work in some version of 3.x). It’s very anyyoing and I really would appreciate if someone could shed some light on this. We even have the effect, that after searching in a date field the date is displayed as it seems in the database? default format, although the database is set to the swiss format as default.
Couple of questions: is this Smart Client or WebClient (or both) and which version are you on?
I’ve just tested this and the following is working fine for me: #28.01.2009|dd.MM.yyyy #28.Jan.2009|dd.MMM.yyyy #28.jan.2009|dd.MMM.yyyy
2008-Jan-26 16:36:00…2009-Jan-26 16:36:30|yyyy-MMM-dd HH:mm:ss
2009-01-01 12:12:12|yyyy-MM-dd h:mm:ss
I did find an issue with a range search on dates combined with not taking into the time (#01.01.2009…31.01.2009|dd.MM.yyyy), which will be fixed.
The database used should not matter, as this is all about the queries generated by Servoy.
The effect that you report Robert, that the final result is in the wrong format I was also not able to reproduce.