I have a calendar view that is supposed to show multiple days where users reserves an equipment. I have created 2 calendar control date/time fields in the form to indicate the start and end date of reservation and created a hidden computed (DateRange) field to calculate the Date Range values.
Formula → @TextToTime(@Explode(@TextToTime(@Text(req_start_datetime) + “-” + @Text(req_completion_datetime))))
I checked that the hidden filed is computing the values as expected.
Within the calendar view, I have set the first column as sorted hidden column with DateRange as the column value and set it to show multiple values as seperate entries. The view seems to be working fine but having an issue when a user reserves an equipment for mutliple days. It shows the entries for the dates within the date range but also shows duplicate entries and entries within and beyond the date range too.
Ex:
Start Date: 05/27/2008
End Date: 05/28/2008
DateRange hidden computed field is storing the values as expcted, i.e:
05/27/2008
05/28/2008
The calendar view shows one entry on 05/27/2008 and corresponding entry on 05/28/2008 (which is correct), but one more on 05/28/2008 and corresponding entry on 05/29/2008 too, which is not even within the date range!!!
I tried various combinations and options, but could not get it to work properly!
Any help in this regard is highly appreciated.
Thanks,