I have a problem with the intervalmatch extended syntax,
see attached file.
it dosent get the tartildato correct when i connect both tables with an intervalmatch.
seems like the problem is that it matches TARIFFRADATO with both LEVFRADATO and LEVTILDATO.
Levfradato and levtildato is the datekey.
syntax:
inner join
IntervalMatch (%DateKey, Kundekontrakt) LOAD TARIFFFRADATO,TARIFFTILDATO,Kundekontrakt,EKSTERNTRESEPTNAMN resident Produktbytte;
Output in QV:
![](/legacyfs/online/146030_pastedImage_2.png)
TaptVunnettable:
![](/legacyfs/online/146031_pastedImage_1.png)
Produktbyttetable:
![](/legacyfs/online/146032_pastedImage_0.png)