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
@uganesh : can you sugggest if i can make modifications in existing code rather than a new logic. Only date comparison part is not working in lookup. I have attached my tmap screenshot for your reference.
@uganesh : can you sugggest if i can make modifications in existing code rather than a new logic. Only date comparison part is not working in lookup. I have attached my tmap screenshot for your reference.
