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…

any ideas?


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