Hi,
I have the below scenario. I get a date from my source system in this format : 2020-05-08(yyyy-mm-dd).
I have to compare this date with 2 dates in my lookup table and check it falls within which range i.e
valid_from valid_to
1.2000-01-01 00:00:00 and 2020-07-01 00:00:00, then pass 19
2.2020-07-01 00:00:00 and 2020-12-31 23:59:59, then pass 16
3.2020-12-31 23:59:59 and 9999-12-31 23:59:59, then pass 19
the query here is how do i compare my incoming date (from tmap) with the dates in this lookup table something like incomingdate > valid_from and incomingdate < valid_to
