Hello Glide community !
I’m having a problem when publishing event registered with date and time Glide columns as starting and ending event dates in Calendar collection component.
As events are registered with hour 0 (for example : 20/08/2024 0:00:00 ) ending day never shows up in calendar component.
Would you please have solution or advise for this issue ?
If you set the ending date to the same column as the starting date, it will take the entire day. Can you try that?
If still not working, try to create computed column format date to remove the hour portion and use it as the starting and ending date, or change the basic date settings to date only.
Try adding any decimal value to your ending date using a math column.
For example:
Date+0.9999
This will add just short of one day to your date, so it should be just before midnight of the next day.
But by doing that, it won’t show as an entire day. It will show as an interval of 0:00:00 to 23:59:59.
But it will show up in the calendar. Your solution doesn’t address events that span multiple days which is what I think the goal is here.
By doing the math method:
By doing the start end same date method:
@Emmanuel I think it is a matter of choice at that point
@Jeff_Hager 's method is nice too!
But if you take the math column method, make sure that the hour on the date column will ALWAYS be 0:00. Otherwise, it may do something like that:
There are ways to get time back to midnight so the 0.999 wouldn’t push you to the next day. The first method is to subtract hour, minute and second, which works but skips milliseconds. The other method involves Trunc, which works but just looks weird in the data editor.
Date-HOUR(Date)/24-MINUTE(Date)/1440-SECOND(Date)/86400+0.999
or
Date-(Date-TRUNC(Date))+0.999
Both methods give the same visual results in the calendar.
2 Likes
Yes ! thank you so much !
Date-HOUR(Date)/24-MINUTE(Date)/1440-SECOND(Date)/86400+0.9999
works fine :
Other TRUNK method looks lighter but doesn’t work as wished
2 Likes