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