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

draghici1109 — Fri, 04 Apr 2025 13:06:09 GMT

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)

;

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

marcus_sommer — Fri, 04 Apr 2025 13:27:58 GMT

Maybe this one:

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

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

draghici1109 — Fri, 04 Apr 2025 15:18:40 GMT

it worked! Thank You! Danke schön!

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

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

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

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