Calendar view not including end date? The view shows one day less

[Surdusvacca]

Hi all,

Not sure why my calendar view is always one day less? Maybe its just how it works, and if it is, I just dont understand why? 🙂

If I add vacation to an employee from 3 january to 4 january, it shows like he is only off the 3. january?


If I edit the vacation from 3 january to lets say 7 january, it shows like if his vacation stops the 6 january?



If I change the 2 columns (Start and End) from Date to DateTime and add time from lets say 7am to 11 pm then the calendar view shows the correct end date like I want to. I just dont need the time.

My first thought was, okay then I just add expression of +1 day, but that would not work cause if an employee is only off 1 day, the expression would +1 day to the 1 day off 🙂 ?

I have checked that everything is in my timezone, both the appsheet and source.
What I am doing wrong? Or is it just how it works?

All the best

[Landan_QREW · Accepted solution]

Here's my best guess. By Default, dates without a time parameter are essentially 00:00:00 AM. For whatever reason, maybe because there is not really any time in the final day of the end date, it is omitting it in the calendar view. To test this theory, you may create a virtual end date with the following computation: [EndDate]+'012:00:00' and use that in the calendar view.

Alternatively, it may be a locale issue.

[Surdusvacca]

Hi Landan_QREW,

Yes that is true, it sees it like 00:00:00
Actually I started to use time also just to get rid of the wrong view.
But I tried your solution with virtual columns, and it fixed it. Thanks a lot 🙂