Finding/searching on dates

Classic Servoy
1

I think this might be a bug (already mentioned somewhere else but the issue continues):

  • When I do a find like:

controller.find();
startdatetime = ‘#’ + utils.dateFormat(new Date(), ‘dd-MM-yy’);
controller.search();

I do a search for a date without the time part and follow the formatting of the search field. This should work but gives me an error message that tells me that the formatting is not correct…

  • Now when I do a find like:

controller.find();
var d1 = new Date(2003, 10, 1);
var d2 = new Date(2003, 10, 30);
startdatetime = ‘#’ + utils.dateFormat(d1, ‘dd-MM-yy’) + ‘…#’ + utils.dateFormat(d2, ‘dd-MM-yy’);
controller.search();

Again, I think I search according to the manuals and search on a range (one month). The error message I get now looks like: ‘java.sql.SQLException: Not all parameters were set. Cannot execute query. Not all parameters were set. Cannot execute query.’

Strange… Is it me? Or something else…

2

in javascript you have to specify the dateformat in youre value:

for example, searching a range with format:

‘1-1-2003…30-1-2003|dd-MM-yyyy’

3

Thanks Johan, that one did it… Maybe you should update the documents for this one. At least I couldn’t find it.

BTW does that mean that searching with a range on dates without the time is not possible? Since the use of ‘#’ still gives that Java error!

4

Is it possible to do a range search without the time-component?

#8-8-2004…10-8-2004

is not working!