HOW TO: Work with and search date fields

Find out how to get things done with Servoy. Post how YOU get things done with Servoy

Postby faheemhameed » Sun Oct 17, 2004 10:13 am

How can I do a range search on dates ignoring the time section of it.

I tried something like the following:

var frmObj = forms.form1;
frmObj.controller.find();
frmObj.entry_date = "#" + utils.dateFormat(globals.srchDate1, "dd-MM-yyyy") +
"..." + utils.dateFormat(globals.srchDate2, "dd-MM-yyyy") + "|dd-MM-yyyy";
frmObj.controller.search();

This some how returns all the records.

I am doing anything wrong here??

Thanks
Hameed
Pilot simple software
Hong Kong
User avatar
faheemhameed
 
Posts: 763
Joined: Wed Sep 10, 2003 7:23 am

Previous

Return to How To

Who is online

Users browsing this forum: No registered users and 9 guests