I first thought sometime with timezone settings, only the strange thing is the time difference between the above 2 activities aren’t the same also, one is 1 hour difference and the other 2 hours…
I need to create a filter so the right activity will be updated within the automation, only i can’t if i don’t get the right activity data…
This looks like a time zone and DST issue. The first date was before the DST change, the second one after - which might explain why one difference is one hour and the other two hours.
In Make, you’ll see times displayed according to the time zone from your own user profile.
There’s a great article on this in the Make help here.
From looking again at the times in your first example, I’m guessing that the Pipedrive API is reporting the times in UTC rather than your local timezone. As they’re not presenting time as a full ISO time (which includes time zone) that makes sense - as otherwise you’d have no way of knowing what time zone was referenced.
However, there doesn’t seem to be any note of this in the Pipedrive API documentation. I did find a few references to UTC issues in the Pipedrive Community, such as this one.
Your best next step would be to raise a ticket with Pipedrive support to ask them to confirm (or otherwise) that time values in the API data are all UTC.
If that is the case, then you’ll need to use the parseDate() and/or formatDate() functions in Make as appropriate.
