Hi "Comment" - sorry to bother again. Closest Date not working after I changed my fields . I have replicated your relationships: closestdate = date (in my case cLookUp = HLDate) and it always returns original HLDate. Simplified I have three relationships between tables:
HLTable - TPTable -> HLID_pk = HLID_fk this is my link to create TPTable from HLTable where I add various dates to my HLDate to derive my new cTPDate. To recap I have the original date from Excel import, HLDate, I bring HLDate to TPTable using a script and the add various dates to HLDate in TPTable to give me my cTPDate
HLTable_lookup - TPTable -> HLDate = cLookup
HLTable_date - TPTable -> HLDate = HLDate (replicating your model), it just returns my original HLDate. Also tried HLDate = cTPDate, which doesn't work same thing - not the closest match.
cLookUp is strictly your calculation whether I reference to HLTable::HLDate it just returns my original HLDate. If I reference to HLTable_date::HLDate, it still returns my original HLDate- not the closest match. If I reference to HLTable_lookup::HLDate or it just crashes.
Any ideas, thanks