Related Data not displaying

Classic Servoy
1

Hi,

Here, i have made a Relation basing upon one calculation and one Datetime field.

like:
calendar_to_appoinment
calendar.calc_start_date = appontiment.onDate

here,
calc_start_date = a calculation which calculates start date of current week.
onDate = a Datetime field which stores the date of appoinments.

But, The above relation is not working.
Any help?

2

Usually a date column in a database also has a time portion. So probably your problem is that you relate something like 2007-01-01 00:00:00.000 to 2007-01-01 14:22:87.654 and that, of course, is not the same. What you could do is create two dates, one has a time portion of 00:00:00, the other 23:59:59. Then you can create a relation with >= and <=.

3

Ok, i am checking that…
Thanks

4

Still it is not displaying Related Records.

5

Then you need to tell us more. How exactly have you setup the relationship? What does calc_start_date evaluate to and what is in the onDate of the record you expect to see?

6

According to you i have changed my relation to like shown in below.

calendar_to_appoinment

calendar.calc_date_time1 <= appontiment.onDate
calendar.calc_date_time2 >= appontiment.onDate

Here,
calc_date_time1 = a calculation which calculates start date of current week with Time stamp 00:00:00
calc_date_time2 = a calculation which calculates start date of current week with Time stamp 23:59:59

Still it is not Working?

7

please.
Any help?

8

Yaa,
patric,
i got the problem.
the problem is about the miliseconds conflicting.

Thanks

9

Good to hear it works :)