# Date and hour format in order to have a record shown in the calendar view

**URL:** <https://community.stackerhq.com/t/date-and-hour-format-in-order-to-have-a-record-shown-in-the-calendar-view/528>\
**Category:** How do I?\
**Tags:** google-sheets\
**Created:** [November 16, 2022, 7:06pm UTC](https://community.stackerhq.com/t/date-and-hour-format-in-order-to-have-a-record-shown-in-the-calendar-view/528 "2022-11-16T19:06:42Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Chartter\_Transport](https://dub1.discourse-cdn.com/flex017/user_avatar/community.stackerhq.com/chartter_transport/32/478_2.png) [@Chartter\_Transport](https://community.stackerhq.com/u/Chartter_Transport)\
**Post date:** [November 16, 2022, 7:06pm UTC](https://community.stackerhq.com/t/date-and-hour-format-in-order-to-have-a-record-shown-in-the-calendar-view/528/1 "2022-11-16T19:06:42Z")

</div>

I want to show, in the “Week” and “Day” views, a record in the according hour instead of as an “all day” event. After trying several possible solutions, I’ve come to the conclusion that the problem is caused by the date and hour format in the corresponding field.

How is the format I have to use in my Google Sheets database?

Thanks

---

<div class="post-metadata">

**Author:** ![Thu](https://dub1.discourse-cdn.com/flex017/user_avatar/community.stackerhq.com/thu/32/51_2.png) [@Thu](https://community.stackerhq.com/u/Thu)\
**Post date:** [November 17, 2022, 4:01pm UTC](https://community.stackerhq.com/t/date-and-hour-format-in-order-to-have-a-record-shown-in-the-calendar-view/528/2 "2022-11-17T16:01:22Z")

</div>

Hi @Chartter_Transport

At the moment we do not support the time format in Google sheets.

Please feel free to add this to our [features request board.](https://stacker.canny.io/feature-requests)