# Help - Date/Time Data Needed for Custom Date Fields **URL:** \ **Category:** APIs & Integrations\ **Tags:** contacts\ **Created:** [November 14, 2018, 9:52pm UTC](https://community.hubspot.com/t/help-date-time-data-needed-for-custom-date-fields/11616 "2018-11-14T21:52:06Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![snamuth](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/snamuth/32/35493_2.png) [@snamuth](https://community.hubspot.com/u/snamuth)\ **Post date:** [November 14, 2018, 9:52pm UTC](https://community.hubspot.com/t/help-date-time-data-needed-for-custom-date-fields/11616/1 "2018-11-14T21:52:06Z")
So, we use HubSpot quite a bit and have run into an issue. I need to be able to report on how long it takes from when a contact is created in the CRM, to when we first attempt outreach to the contact. Is this even possible with the data available in HubSpot? I have tried using a custom date field, and setting the date based on a workflow, that triggers when an attempt is made, but getting the actually date/time stamp doesn’t seem to be easy. Is there something that I am missing, or does HubSpot really not have a way to measure (in seconds/hours) speed to contact or attempt to contact? ---
**Author:** ![IsaacTakushi](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/isaactakushi/32/70387_2.png) [@IsaacTakushi](https://community.hubspot.com/u/IsaacTakushi)\ **Post date:** [November 16, 2018, 9:04pm UTC](https://community.hubspot.com/t/help-date-time-data-needed-for-custom-date-fields/11616/2 "2018-11-16T21:04:36Z")
Hi @snamuth, HubSpot doesn’t have an out-of-the-box solution for this use case, but it’s certainly possible to retrieve and calculate the difference between a contact’s `createdate` property timestamp and a custom date picker property timestamp with a custom integration. Since Hubspot uses [UNIX-formatted timestamps in _milliseconds_](https://developers.hubspot.com/docs/faq/how-should-timestamps-be-formatted-for-hubspots-apis), you would implement the following formula in an external application if you wished to find the difference between a custom “first attempt” timestamp and the contact’s `createdate` timestamp _in days_: `(first_attempt - createdate)÷ 1000 ÷ 60 ÷ 60 ÷ 24` ---
**Author:** ![snamuth](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/snamuth/32/35493_2.png) [@snamuth](https://community.hubspot.com/u/snamuth)\ **Post date:** [November 16, 2018, 10:54pm UTC](https://community.hubspot.com/t/help-date-time-data-needed-for-custom-date-fields/11616/3 "2018-11-16T22:54:07Z")
Thanks [@Isaac\_Takushi](https://community.hubspot.com/u/isaac_takushi) I was able to resolve this using the version timestamp of the custom date property. Since, in my case, the custom date property is set using a workflow and based on an event, I can use the version timestamp for the date value which gives me a timestamp of when the date value was set or updated. This should work, but it would be nice to create custom date/time properties instead of just custom date properties. ---
**Author:** ![IsaacTakushi](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/isaactakushi/32/70387_2.png) [@IsaacTakushi](https://community.hubspot.com/u/IsaacTakushi)\ **Post date:** [November 17, 2018, 2:23pm UTC](https://community.hubspot.com/t/help-date-time-data-needed-for-custom-date-fields/11616/4 "2018-11-17T14:23:21Z")
Hi @snamuth, I’m glad to hear you found an alternative solution! I also see value in such a property! I encourage you to share this feedback on the HubSpot Community Ideas Forum by upvoting and commenting on these similar feature requests: - [First Contacted Date](https://community.hubspot.com/t5/HubSpot-Ideas/First-Contacted-Date/idi-p/17337) - [Report on Lead Response Time](https://community.hubspot.com/t5/HubSpot-Ideas/Report-on-lead-response-time/idi-p/29499) ---
**Author:** ![JGood](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jgood/32/100319_2.png) [@JGood](https://community.hubspot.com/u/JGood)\ **Post date:** [January 11, 2021, 4:08pm UTC](https://community.hubspot.com/t/help-date-time-data-needed-for-custom-date-fields/11616/5 "2021-01-11T16:08:45Z")
If we are passing a Timestamp via API (We are actually using Clearbit and they need to pass a timestamp to us), would I just choose a date field as the type and Hubspot will know what to do with timestamp info that is passed? ---
**Author:** ![dennisedson](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dennisedson/32/28044_2.png) [@dennisedson](https://community.hubspot.com/u/dennisedson)\ **Post date:** [January 11, 2021, 6:44pm UTC](https://community.hubspot.com/t/help-date-time-data-needed-for-custom-date-fields/11616/6 "2021-01-11T18:44:37Z")
Hey @JGood You need to make sure that they timestamp is in unix timestamp format using milliseconds [Here](https://legacydocs.hubspot.com/docs/faq/how-should-timestamps-be-formatted-for-hubspots-apis) is a doc on the subject.