Search on a Date

Classic Servoy
1

Whenever I try a search on this datetime nothing changes. I tried with or without the % and both times I the found variable always equals 200 yet nothing changes on the form? The search date is correct and in a format like ‘2010/06/20’

	var searchStr = utils.dateFormat(globals.glbl_value_date,'yyyy/MM/dd')
	var searchStr = '%' + searchStr + '%';
//	var searchStr = searchStr 
	forms.frm_del_recons.controller.find()
	forms.frm_del_recons.value_date = searchStr
	var found = forms.frm_del_recons.controller.search()

	if(found == 0)
	{	
		plugins.dialogs.showErrorDialog('Not Found',  'No value found : '+search,  'Ok')	
		forms.frm_del_recons.controller.loadAllRecords()
	}
2

% does not work with dates.

what you could to is this:

var searchStr = utils.dateFormat(globals.glbl_value_date,'yyyy/MM/dd')
var searchStr = '#' + searchStr + '|yyyy/MM/dd'; //always give the format here also.....

that will search for that date, no matter what the time component is…