Relationship to calculation date and date field

[Gabe]

I'm having a bit of a problem getting a relationship to work. Basically, I've defined an unstored calculation field that returns Get(currentdate). In a related table I have an actual date field that users enter dates into.

I have specified a non equijoin, greater than relationship from the calculation date field to the actual date field that should only pull records that have a date in the future. Problem is, it just doesn't work.

I know the calculation is working because it shows the number of days since 1 A.D. if I put the field on a layout.

Any ideas? Is there a problem with comparing a calculated date to a stored date?

[Ender]

Check that your calc has a Date result type.

[bikergeek]

You might try using a startup script which sets the value of a global, static currentdate field.

[-Queue-]

Change your relationship to 'less than'. currentdate > datefield will only show records prior to currentdate.