topic Re: How do I create a timestamp with a date and time? in APIs & Integrations

How do I create a timestamp with a date and time?

annieg241 — Mon, 09 Oct 2023 12:37:40 GMT

I want our timestamp properties to include both a date and a time. How can I do this?

Re: How do I create a timestamp with a date and time?

ChrisoKlepke — Mon, 09 Oct 2023 12:45:25 GMT

thank you for reaching out to the community.

That is an excellent question. Datetime properties can be created through the API. You can check this table here for more information and create the property by using this endpoint:

POST /crm/v3/properties/{objectType}

Hope that helps. If you found this post helpful, consider helping others in the community to find answers faster by marking this as a solution. I'd really appreciate it.

Cheers,

Chriso

Re: How do I create a timestamp with a date and time?

annieg241 — Mon, 09 Oct 2023 12:56:22 GMT

@ChrisoKlepke How can I get this date time stamp to work when I am tracking when something occurred? For example, when a contact became "working" I want to track the date and time

Re: How do I create a timestamp with a date and time?

ChrisoKlepke — Mon, 09 Oct 2023 13:00:33 GMT

Hey @annieg241 ,

This is a bit difficult as it is not possible to use the workflow action set property value since it only safes the date to this property. If you have Ops Hub Pro, you can utilize a Custom Code Workflow Action to set that property also with the API.

So in conclusion: You can create the property and set it with a time only through the API as far as I know.

Cheers,

Chriso

Re: How do I create a timestamp with a date and time?

annieg241 — Mon, 09 Oct 2023 16:09:55 GMT

Do you know how I could do that within the API?

Re: How do I create a timestamp with a date and time?

karstenkoehler — Fri, 21 Jun 2024 04:22:08 GMT

Hi @annieg241,

Good news, it's now possible to create datetime properties through the HubSpot user interface 🙂 This feature is in private beta.

Create Datetime properties in HubSpot

June 20, 2024

What is it?

You will now be able create custom Datetime properties in HubSpot’s CRM, expanding the types of data you can store across the Smart CRM.

Why does it matter?

This new field type will allow you to get more insights from your CRM about when something happened. Some use cases include:

Manually edit Time to capture when something happened across the CRM

Require a datetime property when deal record is created

Copy over property values between default & custom datetime properties via a Workflow

How does it work?

Object Settings > Properties > Create Property > Date and Time

Note:

When viewing and editing this property, a user’s current time zone will be used. This is based on the time zone set on their device.

When filtering with this property, your account’s time zone will be used by default.

Any custom datetime properties that had been created via a Support request will now display Date & Time.

‘Date’ properties whose field type can be edited can now be converted to ‘Date and Time.’

Datetime properties will be displayed as Date in the Forms Editor. Datetime properties are not yet supported in the new Forms Editor.

Who gets it?

All hubs and tiers

Learn More:

Join the discussion on our Community

You can check whether you can request this beta here.

If it's not there, you'll have to be patient and check again later.

Best regards!

Re: How do I create a timestamp with a date and time?

georgieh — Wed, 03 Jul 2024 22:30:53 GMT

I was so excited to see this pop up last week - I requested to join the private beta and received a notification it could take up to 3 business days for my request to be reviewed. I went back into Product Updates to check on the status of my request on Monday and I can't find anything to do with create Datetime properties anymore. It appears it might have been removed ☹️

Re: How do I create a timestamp with a date and time?

jaah — Thu, 04 Jul 2024 07:32:22 GMT

Hey @karstenkoehler

Do you know if this beta has been removed again? I could really use it for something i am working on but it is not available when i search for it:

Re: How do I create a timestamp with a date and time?

karstenkoehler — Thu, 04 Jul 2024 07:33:58 GMT

@jaah this is a private beta – so not open to all users yet. I assume the product team will roll this out gradually and, depending on how it goes, also slow down the roll-out, @georgieh.

Re: How do I create a timestamp with a date and time?

AMedinaAlvare — Mon, 28 Oct 2024 17:41:24 GMT

I made one with custom code in Python, then set the property where I store the result. My code saves the day of the week and creation date in text format.

I need it this way to personalize an email.