# End Date on from Big Table not working

**URL:** <https://community.glideapps.com/t/end-date-on-from-big-table-not-working/66589>\
**Category:** Ask for Help\
**Created:** [September 28, 2023, 3:47am UTC](https://community.glideapps.com/t/end-date-on-from-big-table-not-working/66589 "2023-09-28T03:47:07Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Travis\_Anderson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/travis_anderson/32/61251_2.png) [@Travis\_Anderson](https://community.glideapps.com/u/Travis_Anderson)\
**Post date:** [September 28, 2023, 3:47am UTC](https://community.glideapps.com/t/end-date-on-from-big-table-not-working/66589/1 "2023-09-28T03:47:07Z")

</div>

I’m trying to set a end date on a calendar from data from a big table. For some reason its only letting me set a end date with a Date/Time input, I’m trying to calculate duration via “Book Hours”.

It doesn’t give the option to pick a Math, Date Format or template format for the end date.

![Screenshot Glide 2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/7/a763a800cbee62eb296df9877e6304824bf018d6.png)

 ![Screenshot Glide](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/9/c947ca860c007b7438d287bc08106b76ce40b78e.png)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [September 28, 2023, 9:42am UTC](https://community.glideapps.com/t/end-date-on-from-big-table-not-working/66589/2 "2023-09-28T09:42:39Z")

</div>

I’ve not encountered this exact use case, but it doesn’t surprise me that it isn’t supported.  
One thing to be aware of with Big Tables is that computed columns are still evaluated on the client device, which means there are several restrictions around what is and isn’t supported when it comes to Big Tables and computed columns.

If I’m understanding your use case correctly, what you will need to do is create another (non-computed) date/time column to hold the booking end date, and set that when the booking is created. If you want the value to be dynamically calculated based on a given number of hours, then you may need to use a Custom Form.

A full list of Big Tables limitations is given below:

> **[Big Tables](https://www.glideapps.com/docs/essentials/data-sources/big-tables#limitations-of-big-tables)**
>
> Scale your app with up to 10 million rows of data.