search on date without time

Classic Servoy
1

Hello,
I would like to search a record by his date, without use his hours, minute or second.

I know I can use ‘#’ symbol :

for example: #30/10/06 in the field and it work It return all record create the 30/10/06

But if I use <= #30/10/06 it return all record in my database and records created the 31/10/06

Thanks,

2

Hi Fabien,

You need to add the dateformat in the searchstring.
If you check the Servoy help under Getting Started > Finding Data > Find dates and times you find the following:

controller.find();
startDateTime = '#1-1-2004|MM-dd-yyyy';
controller.search();

There are also examples in the help for searching data ranges.

Hope this helps.

3

I solved my problem. I change the time of my date and I execute my search method.

globals.tp_datetime1 = new Date(globals.tp_datetime1.getFullYear(), globals.tp_datetime1.getMonth(), globals.tp_datetime1.getDate(), 23, 59, 59)

date =  "<= " + utils.dateFormat(globals.tp_datetime1,'dd/MM/yy HH:mm:ss') + '|dd/MM/yy HH:mm:ss';