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.
Solved! Go to 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
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
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!
User | Count |
---|---|
37 | |
25 | |
21 | |
20 | |
16 |