How to display data from a date field between two dates
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')
