30Mar23 0537 weird Appsheet calendar display

[Techuke]

30Mar23 Hullo Appsheet titans! Greetings from New Zealand. For time periods longer than one day, what causes the Appsheet calendar to display one day less than correct? For example the screenshot shows two events. The red event dates are 3Apr to 7Apr. And yellow dates are  4Apr to 6Apr. But Appsheet displays durations one day less than expected. Any insights  .. much appreciated.

[WillowMobileSys · Accepted solution]

I believe this is a bug and should be reported to AppSheet.  I found that if I defined the columns as DATETIME and set the time portion to something other than Midnight, then the Calendar range shows correctly.  See images

DateTime columns - Midnight time - Incorrect Calendar range

Date columns - Incorrect Calendar range

DateTime columns - Time 1 second past Midnight - Correct Calendar range

[Techuke]

4Apr23 0559 thank you very much WillowMobileSys for your workaround. It works well. Eventually I used another workaround. A bit klutzy! Users enter their desired dd/mm/yy end DATE. But using a virtual column I display DATE + 1 if the end-date > start-date. What would we do without bugs!