Time column always include dates in computation

Ask for Help
1

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
CnP_20012026_170654680×276 26.6 KB

CnP_20012026_170722
CnP_20012026_170722388×402 10.6 KB

CnP_20012026_170743
CnP_20012026_170743388×436 9.47 KB

2

  • 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.

3

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
image427×658 18.7 KB

image
image434×255 24.9 KB

4

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
5

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
image549×268 24.1 KB

image
image388×277 7.49 KB

6

yes, unless you want everything to be open from midnight (00:00) until the end time.

Hour(StartTime) + Minute(Start time)/60

3 Likes