Hello everyone,
I'm trying to select data in an app using date selection, the selected date should select the data based on two date fields.
Here my example data:
| SOURCE |
CUSTOMERID |
SYS_START |
SYS_END |
| ORIG |
123 |
0001-01-01 00:00:00.000 |
9999-12-30 00:00:00.000 |
| ORIG |
456 |
0001-01-01 00:00:00.000 |
9999-12-30 00:00:00.000 |
| HIST |
789 |
0001-01-01 00:00:00.000 |
2023-04-21 12:21:35.223 |
| HIST |
789 |
2023-04-21 12:21:35.223 |
2023-05-04 08:08:09.226 |
| ORIG |
789 |
2023-05-04 08:08:09.226 |
9999-12-30 00:00:00.000 |
I am now trying to select a date from a date picker and based on the columns SYS_START and SYS_END the appropriate customer information should be selected --> the selected date must therefore lie between these two dates.
As an example:
Chosen Date: 2023-05-01 should result in:
| SOURCE |
CUSTOMERID |
SYS_START |
SYS_END |
| ORIG |
123 |
0001-01-01 00:00:00.000 |
9999-12-30 00:00:00.000 |
| ORIG |
456 |
0001-01-01 00:00:00.000 |
9999-12-30 00:00:00.000 |
| HIST |
789 |
2023-04-21 12:21:35.223 |
2023-05-04 08:08:09.226 |
Hopefully I was able to describe my search well and maybe someone already had a similar topic and an idea for me?
Thank you and best regards,
Markus
