Hi all, I am having this issue and I’m desperate to find a solution.
Im having an issue when converting a time and date using the parseDate function.
Why is {{parseDate(2024-03-20 00:20:47; “YYYY-MM-DD HH:mm”)}} returning 2024-03-19T 23:20:00.000Z?
Why an I getting 1 hr subtracted? The parsing looks correct.
I get the following error:
The operation failed with an error. [400] Property values were not valid: [{“isValid”:false,“message”:“1710890447000 is at 23:20:47.0 UTC, not midnight!”,“error”:“INVALID_DATE”,“name”:“upload_date”,“localizedErrorMessage”:“1710890447000 is at 23:20:47.0 UTC, not midnight!”,“propertyValue”:“1710890447000”,“portalId”:144659972}]. HubSpot Correlation ID: ae5c85f9-d5fa-41f9-b18d-480f76451f04
I would really appreciate if someone could help.