Date as a calculation
I am trying to use a field that is a calculation (with the result set as a date) in a match field for a relationship with another date field. It doesn't seem to be working.
Created a text field and used replace field contents with that of the calculated field and used it as a match field and it worked.
So I think that it must be something to do with the formatting of the date or a calculated date field.