Google Calendar - Todays events to disappear when end time is exceeded.



I have successfully extracted the information I need from my google calendar, BUT I would like them to disappear from klipfolio as soon as the events end time is exceeded.

I am no coder, so any help would be appreciated.



1 comment

  • 0
    Janice Janczyn

    Hi Egil,

    You can compare your events end times with the value returned by the NOW function. NOW returns Unix time so your end times will have to be converted to Unix for comparison, for example 

         DATE( @/items/end/dateTime, "yyyy-MM-dd'T'HH:mm") <= NOW()

    You can use this comparison to filter your data using Filters or as a condition in a SELECT function. If this doesn't answer your question, please provide a few more details about how you intent to display this data in a klip.


Please sign in to leave a comment.