Currently the query does not return data for the endDate. For example, if I the end date is June 27, it won't return any results for June 27, only June 26th and before depending on the startDate value.
I believe the correct behavior should be to 1) not enforce the day 2 offset. 2) allow the user to select the same startDate and endDate value in order to get results only for the that day selected.
As a work around, I'll update datePickers to the #endDate variable in the SetDate functions to "+1". This will allow "tomorrows" date to be selected, but will only returns todays date.
Currently the query does not return data for the endDate. For example, if I the end date is June 27, it won't return any results for June 27, only June 26th and before depending on the startDate value.
I believe the correct behavior should be to 1) not enforce the day 2 offset. 2) allow the user to select the same startDate and endDate value in order to get results only for the that day selected.
As a work around, I'll update datePickers to the #endDate variable in the SetDate functions to "+1". This will allow "tomorrows" date to be selected, but will only returns todays date.