Datetime and date options into properties

We'd like to have a workflow to copy 'Became Marketing Qualified Lead' date from the contact to the associated company. 

 

As far as we've understood, that's not possible because that field being type datetime, and the properties you can create can only be date. 

 

Would it be possible to add datetime as an option for the property type?

 

Screen Shot 2018-06-14 at 15.46.15.png

HubSpot updates
5 Replies
Tyler-Tegen
New Contributor

We need this.

CorbinAssembla
Occasional Contributor

The ability to copy datetime into date fields is an alternative option that would be very helpful. Either way, there needs to be some way to copy from the "Became a [lifecycle] date" fields. Primarily because the data in those fields is reset whenever a lifecycle stage moves back in time and the dates are lost. It would be nice if we could copy the data from those fields into custom fields prior to pushing a contact backwards in the lead funnel (e.g. from Sales Qualified Lead to Subscriber).

mnagel
New Contributor

Especially important with the new types of workflows now available. Deal/ticket/quote datetime objects to custom contact and company date picker fields and vice-versa.

jonnoprice
New Contributor

We need this exact same thing. We want to capture "Became an MQL date" but on a company level. I've created a property on the Company level "Became a Company MQL" - but when trying to use a workflow to copy the Became a MQL Date (from a contact) to the company level it does not seem possible.

 

If there is any advice or help that would be apprecited. 

 

We want to be able to report on companies that became MQL (not leads) - and the date at which they became MQL..

jonnoprice
New Contributor

Hi all - I've figured out a workaround for this.

 

1.) Create a new Contact level property using Date Picker field type (e.g. "BecameMQL Date")

2.) Create a new Company level propery using Date Picker field type (e.g. "Became Company MQL Date")

3.) Set up a Contact Workflow - Trigger is on when the default "Became a Marketing Qualified Lead" date is Known.

Add an update contact property action that then adds a date stamp to the "BecameMQL Date" field.

Add another action to copy the "BecameMQL Date" contact property to the "Became Company MQL Date" company  field.

 

After nearly 2 hours of trying different things the above seems to work. 

 

Note:

- you cannot copy the default Became a MQL date to a company field (this is because of time stamp)

- similarly you cannot add a Date Stamp to a date field on a company record. There is no explanation why this is so.. 

- but you can add a Date Stamp to a contact field (date picker) and the copy that to a company field (date picker)..

 

Bizarre but true.