> Date Search

Classic Servoy
1

Hello,

Trying to do a simple “find dates greater than”

This code “finds” all records:

var vDate = utils.dateFormat(new Date(2006,10,03),‘MM-dd-yyyy HH:mm:ss’);
application.output(vDate);
controller.find();
date1 = “>” + vDate;
controller.search();

application output looks like 11-03-2006 00:00:00

Suggestions appreciated.

2

got it. this works:

var vDate = utils.dateFormat(new Date(2006,10,03),‘MM-dd-yyyy HH:mm:ss’);// Months start at 0!
controller.find();
datefield = ‘>’ + vDate + ‘|MM-dd-yyyy’;