Date Calc RelationI

[Ians]

Hi All,

I've made a date calc:

If ( AC.Report Date ≥ AC.gDate Range Start and AC.Report Date ≤ AC.gDate Range End ; 1 ; 0 )

Which does return a "1" when a date falls in the range, but when I use this as the right hand side (left is a fixed "1") of a relation nothing shows up in the portal.

Any ideas?

Thanks

Ian

Edited March 13, 2006 by Guest

[comment]

Right-hand side fields must be indexable.

[Ians]

Right-hand side fields must be indexable.

Could you expand on that please?

Ian

[comment]

I am guessing that 'AC.gDate Range Start' is a global field? That would force your calculation to be unstored, thus not indexable. Unstored calcs cannot be used for the right-hand side of a relationship.

Instead of the calc, make your relationship this way:

gStart ≤ Date

AND

gEnd ≥ Date

Edited March 13, 2006 by Guest

[Ians]

ok, I'll give it a try.

Thanks