Oct 19, 2019 8:19 AM
I was in the process of building out workflows that would copy a 'Became a' date from an associated contact to a custom Company property if it is unknown at the company level. This would allow us to capture at the company level WHEN the company became a lead, MQL, SQL, etc. However, I ran into the 'can't copy from a datetime field to a date field' issue when building out the workflow (the custom company properties are date picker fields since that's all you can set them as via the UI).
Are there any workarounds to this? This is critical to us for reporting purposes (we need an exportable solution as well as something within HubSpot).
Thanks in advance!
Solved! Go to Solution.
Oct 19, 2019 10:30 AM
You should be able to achieve the deisred out come using the 'set a company property' action to 'set a date stamp' to the current date.
Checking if the property is unknown is a good way to prevent the 'became a' date from updating with each new contact. I do this using the company lifecycle stage itself, which I have mapped to the associated contacts.
Hope this helps.
Oct 19, 2019 11:13 AM - edited Oct 19, 2019 11:14 AM
The problem is that , when creating the action in the workflow, the custom company property I created isn't an option as a target property because it's a date picker property and the source contact property is a date/time property.
HubSpot seems to confirm that the roadblock I'm encountering is correct:
"In order to copy a date property value to another date property, the two date property types must match, or the source property must be a date picker property and the target property must be a datetime property. It is not possible to copy datetime property values to date picker properties, because the date picker properties can't store the timestamp."
I was hoping there was something I'm either missing or a workaround. And thanks for confirming the 'Is Unknown' piece of this!