Good day
I have two tables containing dates and data. I would like to display data from one date field that lies between two dates. This is what I have done so far, but I don't seem to get an answer.
| KeyID |
PreviousStartTimestamp |
StartTimestamp |
EndTimestamp |
Value |
| 2349 |
2022-02-17 : 04:32:35 |
2022-02-17 : 05:11:21 |
2022-02-17 : 05:14:05 |
0.52 |
| 2349 |
2022-02-16 : 10:03:29 |
2022-02-17 : 04:42:50 |
2022-02-17 : 05:11:21 |
0.53 |
| 2349 |
2022-02-16 : 09:52:51 |
2022-02-17 : 04:32:35 |
2022-02-17 : 04:42:50 |
0.53 |
| 2349 |
2022-02-16 : 09:44:33 |
2022-02-16 : 10:03:29 |
2022-02-17 : 04:32:35 |
0.53 |
| 2349 |
2022-02-16 : 07:43:01 |
2022-02-16 : 09:52:51 |
2022-02-16 : 10:03:29 |
0.52 |
| KeyID |
FromDate |
ToDate |
value2 |
| 2349 |
2022-02-17 : 05:05:21 |
2022-02-16 : 15:18:00 |
6.403 |
| 2349 |
2022-02-17 : 04:35:50 |
2022-02-16 : 12:45:00 |
5.064 |
| 2349 |
2022-02-17 : 04:30:35 |
2022-02-16 : 09:39:00 |
5.075 |
| 2349 |
2022-02-16 : 10:00:29 |
2022-02-15 : 17:09:00 |
2.194 |
| 2349 |
2022-02-16 : 09:25:51 |
2022-02-15 : 14:15:00 |
6.922 |
if(FromDate>PreviousStartTimestamp and FromDate<EndTimestamp, dtFromDate, 'f')
Why is this not working
