Comparing two dates and check for not falling dates

[rajinikanth]

Hi All

I have two tables as below.

Need to compare Date from T1 with Start_date and End_date from table 2  and pull only Dates that are not falling between. (Note : can do this by joining two tables, but the volume of data is huge so cant approach this solution).

Result should be 1-jan-2018,  as it doesn't fall between any of the satrt_date and end _date

T3:

Date

1-Jan-18

T1:

Date

1-Jan-18

23-Apr-18

T2:

satrt_date	end _date
31-Mar-18	24-Feb-19
31-Mar-18	24-Feb-19

[JordyWegman]

Hi Rajinikanth,

You can do the following. Now you only get the dates who do not fall in between the dates.

IF(Date >= [start_date] AND <= [end_date],null(),Date)

Jordy

Climber 

[rajinikanth]

This above solution, i can use when i have Date , start_date,end_date in one table.

I don't want these two tables to be joined, as my data is huge and hamper the performance with this join.