I am using HubDB to display a list of webinars. I use the following columns: event_start_date = start date of the event ev…

Hi Sven, you must put inside your for cycle this strings: {% if (row[‘event_start_date’]|datetimeformat(‘%j’)) >= (local_dt…

Rather than filtering by date in your for loop, it is better to filter the query itself {% set queryparam = “&orderBy=start_…

@giozua - It appears that string of code works if the event dates are within the same year (ex. past 2018 events don’t show u…

Hi @leckerman , I want to see if other HubDB users are experiencing this issue @Jlamb1 and @stefan are you experiencing the s…

@jennysowyrda - I was able to find help in the HubSpot slack group on Friday. Key was to add “&datetime_column__gt=0s” to the…

Try this {% if (row[‘event_date_start’]|unixtimestamp)>=(local_dt|unixtimestamp)%} It should work Giovanni

Hi @giozua , This solution work perfect when we use ‘%j’ in a timestamp but the thing is this condition doesnot show up the …

Hi @jasonvanpelt , so i tried the cod and it works perfectkly. However i am not able to show the events for the next 30 days. …

Filter HubDB data based on today's date

leckerman October 9, 2018, 2:03pm 4

Can anyone help with this? It appears that new 2019 event dates are not showing up either with that string of code. Please help!

Topic		Replies	Views
Filter HubDB data based on today's date SOLVE CMS Development free	2	1293	March 18, 2021
HubDB Query to filter all dates older than today APIs & Integrations developer-tools	3	3297	March 16, 2021
remove posts before today from listing view CMS Development	3	1568	September 26, 2018
Hubl filter to show future hubdb events used in rich text editor CMS Development hubdb	4	2558	July 4, 2024
Hubdb Filter on Date CMS Development hubdb	3	2922	September 29, 2020