Workflow "Send a Webhook" is sending wrong data.

[MHarp]

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.

[karstenkoehler · Accepted solution]

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!