Hi all

Been trying to get my portal to filter the welders continuity records and not having any luck.

The relationship on which I created the portal is as follows

[color:blue]expiration date (greater than or equal to) start date

and

expiration date (less than or equal to) end date

this doees not show any records in the portal.

The expiration date is formatted as date.

The start date is a calculation formatted as a date

the end date is a calculation formatted as date.

I tried changing the format of these fileds a dozen times trying to get this to work. I know I got something wrong but I can not figure it out.

I included a sample file of what I am trying to do.

Thanks for the help in advance.

Lionel

continuity.zip

2 Issues here:

I think your relationship is reversed (should be from start and end date to expiration date, right?)

and

expiration date needs to be a stored calc for the relationship to work.

See attached.

continuity_welder.fp7.zip

thanks for the help. works perfectly

Lionel