Timing issue with HubSpot API on calculated property?

Developer Support APIs & Integrations
1

I am running into what appears to be a timing issue with the calculate property hs_v2_date_entered_{stage_id_x}

I have a deal with “hs_v2_date_entered_{stage_id_x}”:“2025-07-07T14:34:40.199Z”} and it happens to be in the specific stage I need “dealstage”:“{stage_id_x}”

On calling the API at 16:00 this deal was not returned by the API

{

“filterGroups”: [

{

“filters”: [

{

“propertyName”: “dealstage”,

“operator”: “EQ”,

“value”: “{stage_id_x}”

},

{

“propertyName”: “hs_v2_date_entered_{stage_id_x}”,

“operator”: “GT”,

“value”:1751898008000

}

]

}

],

“properties”: [

“dealname”,

“hs_v2_date_entered_{stage_id_x}”,

“dealstage”

],

“limit”: 200

}

1751898008000 is July 7, 2025 at 14:20:08

On makingthe same request today July 8, now that data is being returned.

Why is this the case

2

How are you retrieving the first date value? If you’re going through the Hubspot website then it’s very likely the date is being adjusted for the timezone of your account while the API request is returning the UTC value. So if you’re in any time zone with a negative adjustment, that deal wouldn’t be returned.

3

I calculate the date by getting the current unit time stamp in milliseconds and then subtract 40 minutes.

I then used the exact value run when it got nothing 6 mins after the change, which now returns data on the next day

If I can eventually get the data, that would confirm that the date is correct I would think, although I am being cautious here.