Date Range

Developer Support CMS Development
1

Hi everyone,
I am trying to get those tickets and I am having issues pulling those tickets in between those two dates (start_date and end_date)
here is my query
{% set tickets = crm_associations(companyID, “HUBSPOT_DEFINED”, 25, “limit=100&createdate__gte=”~start_date~“&createdate__lte=”~end_date, “id,subject,createdate,hs_created_by_user_id”,false) %}
not sure what I’m missing here.with this one {% set tickets = crm_associations(companyID, “HUBSPOT_DEFINED”, 25, “limit=100”, “id,subject,createdate,hs_created_by_user_id”,false) %} , I don’t have a problem, but I want to set a date range

2

Hi, @DBarro :waving_hand: Thanks for your question! Hey, @dannio @mangelet, do you have any thoughts on how @DBarro can structure their request?

Thank you! — Jaycee

3

@DBarro what format are you using for the start and end dates? I suspect you might not be using a timestamp in your query. Can you try again after you convert the time into a timestamp?

{{ start_date|unixtimestamp }}