show only related records with a date greater than today

Classic Servoy
1

Hello guys
I’m trying to display a list of records based on a relationship, but only those that have a start_date greater than today.
I made a global variable vTodayMorning which I set to this morning:

globals.vTodayMorning = new Date();
globals.vTodayMorning.setHours(0,0,0,0);

then I create a relationship where I select on the related table start_date >= globals.vTodayMorning, but it shows all records. What am I doing wrong?

Thanks
Gabriel

2

This ought to work. Can you have a look at the query fired at the database?

Paul

3

Thank you Paul for your answer. Is there a way to see the sent querry, other than sniffing on the connection?

Gabriel

4

On the Servoy Admin pages you can see the queries in the Performance log

Paul

5

Silly me,
it was working, only that the comparison sign should have been the other way around. This is what happens when you do it in a hurry.

The global variable is, of course, on the left side of a relationship, so I should have said globals.vTodayMorning <= start_date.

Please close and delete this thread :D

Thanks,
Gabriel