Filter by same date
Hi all Good Day to you.
i have an issue when i filter from the same date for example:
*DateFrom = 1/12/2023
*DateTo = 1/12/2023
the date above then will be filter based on start date and end date of a data and it will appear to a booking table data based on that date accordingly.
and the issue occur when a data with start date on 1/12/2023 and the end date is 3/12/2023, it will not show in the table because of the logic only apply to filter for the date above (1/12/2023). how do i resolve the issue so that even if the filter date is as above example, the data shown will also include data that have the same start date as the value *DateFrom = 1/12/2023 regardless if the end date is same or not with *DateTo = 1/12/2023.