Set UNIX timestmp to midnight UTC

From a date/time timestamp, I need to get the Unix Millisecond Timestamp set to midnight.

HubSpot’s date picker only accepted Unix Millisecond Timestamps that are set to midnight, or else they will error…https://community.hubspot.com/t5/APIs-Integrations/Contacts-API-not-accepting-timestamp/m-p/232231

any ideas?

@Peter_Luba

Try this:
{{formatDate(setHour(setMinute(setSecond(now; 0); 0); 0); "X"; "UTC")}}000

Replace now with whatever date you want to adjust.


Jim - The Monday Man (YouTube Channel)
What is Make & How can it help you?
We Create Custom Solutions
Schedule a 1-on-1 Tutorial Session (for monday, Make & Apples v. Oranges)

1 Like