Search Dates

Classic Servoy
1

I’ve created a find form based on globals.

I’m trying to offer a search by date :
Find all actions with action_date >= globals.date1
or <= globals.date2
or globals.date1 <= action_date <= globals.date1

I’ve work on it but without results :

Help and forum proposes :
//performs a find for a date range in startDateTime
controller.find();
startDateTime = ‘1-1-2004…1-30-2004|MM-dd-yyyy’;
controller.search();

but I can’t find the right syntax for the use of variables instead of values…

I hoped something like this would work :

forms.action.controller.find()
forms.action.action_date = ‘>= globals.date1’
forms.action.action_date = ‘<= globals.date2’
forms.action.controller.search()

…but it doesn’t.
Any ideas?

thanks in advance.
Johann

2

To be more accurate I hoped I could do something like :

forms.action.controller.find()
if (globals.date1)
{
forms.action.action_date = ‘>= globals.date1’
}
if (globals.date2)
{
forms.action.action_date = ‘<= globals.date2’
}
forms.action.controller.search()

:?

3

I’ve omitted the following post in my previous search of the forum :

http://forum.servoy.com/viewtopic.php?t … dateformat

:roll: