Format epoch time value to date picker property

[MarcoPericci]

Hi!

I need some help about the format date action in workflows.

I use a custom code action to trigger a webhook that import values form our internal app database.

Some of these values are unix epoch date and I need to convert it to date and put in a date picker property.

Someone can help me?

[Mike_Eastwood · Accepted solution]

Hi @MarcoPericci 

If your Custom Field is set up as a Date Property then it will show as a Pate Picker in the CRM.

Is that what you meant?

If it's not feel free to send em a message and we can jump on Zoom.

Mike

[Mike_Eastwood]

Hi @MarcoPericci 

If the date hasn't validated, and it's flushed, it will result in zero which is Epoch time* (00:00:00 UTC on 1 January 1970).

Are you converting your date to microseconds before passing it to HubSpot?

Did that work?

Mike

[MarcoPericci]

Hi @Mike_Eastwood !

The date that I import by a custom code inside a workflow is not empty.

Is expressed in epoch format in millisecond but is not zero.

The problem is How to convert this long number in a date picker property.