# Time column always include dates in computation **URL:** \ **Category:** Ask for Help\ **Created:** [January 20, 2026, 9:09am UTC](https://community.glideapps.com/t/time-column-always-include-dates-in-computation/86076 "2026-01-20T09:09:14Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Arrafi\_Wardhana](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/arrafi_wardhana/32/93726_2.png) [@Arrafi\_Wardhana](https://community.glideapps.com/u/Arrafi_Wardhana)\ **Post date:** [January 20, 2026, 9:09am UTC](https://community.glideapps.com/t/time-column-always-include-dates-in-computation/86076/1 "2026-01-20T09:09:14Z")
how can I create a session schedule where if the current time is before the Schedule ends, than that session is still available? i’ve been encountering this issue I have a session table, and there are 4 sessions, (07:00 - 09:00, 09:00 - 11:00, 14:00 - 16:00,16:00 - 18:00). How can I create a logic where if the current Time is before this session end time, then True (this session is bookable as a Choice component) If I pull the EndTime from the Date column, it still adds the Date (of which I populate the column) into the calculation. if I use a template column which takes only the Time out of the Date column, the math column could not recognize it as a number to substract since it says 7:00 AM ![CnP_20012026_170654](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/9/19f391c9259bbc709bd065b7be088cc0f9431837.png) ![CnP_20012026_170722](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/d/0d565f554b09a41fa7ab97598a0ab3c3b76b170d.png) ![CnP_20012026_170743](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/a/5a7eb4a6aca1e5f0bf875753afa6143ba5a17123.png) ---
**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:** [January 20, 2026, 10:08am UTC](https://community.glideapps.com/t/time-column-always-include-dates-in-computation/86076/2 "2026-01-20T10:08:49Z")
- Is Active: – If Start Time is after `Now`, then `null` (leave empty) – If End Time is after `Now`, then `true` - Is Open: – If End Time is after `Now`, then `true` In all cases above, `Now` should be the Current Date/time (not a math column). The above also assume that you consider an event “Open” if the end date & time is after the current date & time. ---
**Author:** ![Arrafi\_Wardhana](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/arrafi_wardhana/32/93726_2.png) [@Arrafi\_Wardhana](https://community.glideapps.com/u/Arrafi_Wardhana)\ **Post date:** [January 20, 2026, 12:19pm UTC](https://community.glideapps.com/t/time-column-always-include-dates-in-computation/86076/3 "2026-01-20T12:19:10Z")
It doesnt seem to work. I use the “Now” as the time reference, and its always real time, but it seems that my Date & Time Column is fixed to the date in which I populate them even though I only use the Time format. \*the math column shown is only as reference for the current time ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/e/1e31a3d2d70bdd1a5efd823a7f163d31c8ce0fc7.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/6/96714ae80cb780a6d4f608812449e268af781aff.png) ---
**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:** [January 20, 2026, 12:25pm UTC](https://community.glideapps.com/t/time-column-always-include-dates-in-computation/86076/4 "2026-01-20T12:25:53Z")
I think I may have misunderstood how you define “Is Active”. I assumed that an Event would only be active if the current time _and_ date were within the event window. Is that not the case? If you want to ignore the dates completely, then you are better of using a series of math columns to extract the hour of day, and then compare those in the if-then-else column. - Start Hour: `Hour(StartTime)` - End Hour: `Hour(EndTime)` - Hour Now: `Hour(Now)` And then in your if-then-else column: - If Hour Now is less than Start Hour, then `null` - If Hour Now is less than End Hour, then `true` ---
**Author:** ![Arrafi\_Wardhana](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/arrafi_wardhana/32/93726_2.png) [@Arrafi\_Wardhana](https://community.glideapps.com/u/Arrafi_Wardhana)\ **Post date:** [January 20, 2026, 12:43pm UTC](https://community.glideapps.com/t/time-column-always-include-dates-in-computation/86076/5 "2026-01-20T12:43:42Z")
It works, thank you. is the StartHour crucial in the ITE? also. if the Hour has specific minutes (e.g. 23:30), how do we specify this in the Math Column? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/6/463e7792f34c1b5e2a61ffe872197ec10066266a.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/d/dd432471831c5f49b43090b9ddbcd97012618ed8.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 20, 2026, 1:06pm UTC](https://community.glideapps.com/t/time-column-always-include-dates-in-computation/86076/6 "2026-01-20T13:06:30Z")
> [@Arrafi\_Wardhana](#): > > is the StartHour crucial in the ITE? yes, unless you want everything to be open from midnight (00:00) until the end time. > [@Arrafi\_Wardhana](#): > > the Hour has specific minutes (e.g. 23:30) Hour(StartTime) + Minute(Start time)/60 ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [January 27, 2026, 1:06pm UTC](https://community.glideapps.com/t/time-column-always-include-dates-in-computation/86076/7 "2026-01-27T13:06:58Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.