Any date fields I try to send via a webhook in a Hubspot workflow is coming across as a number that is not the date. For example, today, Hubspot sent a date that is listed as 1/24/24 as “1706054400000.”
Similarly, it sent “1701302400000” for the date 11/30/23.
Do you know what this is? Could it be an internal value for the date? How could I get this to send the actual date instead of this number string that doesn’t mean anything.
Hi @MHarp,
That looks like an Epoch Unix Timestamp. Unix time, also known as POSIX time or epoch time, is a system for tracking time in computing, defined as the number of seconds that have elapsed since 00:00:00 Coordinated Universal Time (UTC), Thursday, 1 January 1970 (excluding leap seconds).
To convert it to a human-readable date and time, you can use various tools or programming languages. Here is an example in Python:
from datetime import datetime
timestamp = 1701302400000 / 1000 # Convert milliseconds to seconds
dt_object = datetime.utcfromtimestamp(timestamp)
print("Real-time:", dt_object)
Hope this helps!