Issue with field in date (YYYY.MM.DD) format

[draghici1109]

Hello community!

I struggle with the following issue: 

Having this table as an input:

I want to eliminate the third record, due to the fact that Between IntervalStart and IntervalEnd is a difference of one day. And yet this where clause does not work... why?

Final:
NoConcatenate
LOAD *

resident [FinalTable]
WHERE IntervalStart + 1 <> IntervalEnd
//WHERE Num#(date(IntervalStart,'YYYY.MM.DD')) +1 <> Num#(date(IntervalEnd,'YYYY.MM.DD'))
//WHERE date(IntervalStart,'YYYY.MM.DD') +1 <> date(IntervalEnd,'YYYY.MM.DD')
//WHERE Num#(IntervalStart) + 1 <> Num#(IntervalEnd)

;

[marcus_sommer · Accepted solution]

Maybe this one:

WHERE date#(IntervalStart, 'YYYY.MM.DD') + 1 - date#(IntervalEnd, 'YYYY.MM.DD');

[draghici1109]

it worked! Thank You! Danke schön!