Servoy Forum

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:

Code: Select all

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

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

Paul

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

Gabriel

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

Paul

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

Thanks,
Gabriel