Comparing dates

Classic Servoy
1

I have a datetime field which contains both date and time. I need to create a relationship to just the date portion (day, month, year, disregard time). Presumably this requires a calculation. But I’ve been unable to locate the appropriate syntax.

Separate matches for each of day, month, year (which would require separate calcs for each)? Or is there something more efficient?

Thanks

2

set the time proportion to 0

calculation:
var a = date
a.setHours(0)
a.setMinutes(0)
a.setSeconds(0)
a.setMilliseconds(0)
return a

Do this this for both sides of the relation (left and right) and you can use them in a relation!

3

Excellent, Harjo! Thanks.