# After hours ticket data report

**URL:** <https://community.hubspot.com/t/after-hours-ticket-data-report/82061>\
**Category:** Tickets & Conversations\
**Tags:** reports\
**Created:** [May 25, 2023, 9:38pm UTC](https://community.hubspot.com/t/after-hours-ticket-data-report/82061 "2023-05-25T21:38:35Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![EWeinberg](https://avatars.discourse-cdn.com/v4/letter/e/f6c823/32.png) [@EWeinberg](https://community.hubspot.com/u/EWeinberg)\
**Post date:** [May 25, 2023, 9:38pm UTC](https://community.hubspot.com/t/after-hours-ticket-data-report/82061/1 "2023-05-25T21:38:35Z")

</div>

Hello Hubspot users!  
I am looking to create a report for all tickets that are created outside of normal business hours. Specifically all tickets that are created Monday through Friday from 8p EST and 9a EST, and 6p EST Saturday to 9a Monday. I cannot seem to find the time metric, only the date. Is there any way to complete this or is time not a supported filter in Hubspot?

Thank you!

---

<div class="post-metadata">

**Author:** ![kvlschaefer](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/kvlschaefer/32/71076_2.png) [@kvlschaefer](https://community.hubspot.com/u/kvlschaefer)\
**Post date:** [May 26, 2023, 12:46pm UTC](https://community.hubspot.com/t/after-hours-ticket-data-report/82061/2 "2023-05-26T12:46:19Z")

</div>

Hi @EWeinberg,

Thanks for reaching out to the Community!

This is a great question 🙂

There is a limitation in HubSpot on timestamp reporting. This is the reason why you’re not able to see the time when you create a report based on the ticket “create date”. I would recommend upvoting this r[elated feature request](https://community.hubspot.com/t5/HubSpot-Ideas/Add-Timestamp-as-a-property/idi-p/214294) in the Ideas Forum!

That being said, there are two workarounds you can consider if you have **Operations Hub** or **developer resources**.

**Operations Hub Professional or Enterprise**

You could track the number of tickets created outside of hours by creating a custom “ticket create date and time” property and then exporting the data to Excel from a HubSpot report!

You can create a **single line text property** to be your new “ **create date and time property** ” and then you can create a **ticket-based workflow** that will do the following.

1) Enrollment: Ticket Create Date = known

2) Format Data \> Create date \> Format it to be (MM/dd/yyyy hh:mm a)

3) Copy Property Value \> Copy the value “[String] value” from “1.Format data” to your custom ticket property

 ![Screenshot 2023-05-26 at 8.27.56 AM.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/b/c/bc4739b1780c537446108eac790ee9aff50388b0.png)

The outcome will look like this:

 ![Screenshot 2023-05-26 at 8.35.08 AM.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/9/e/9e1078776eb015f19da7cba6451e8145845b91c6.png)

 ![Screenshot 2023-05-26 at 8.32.09 AM.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/0/a/0a9061e66a20a01eb11640c531dea28b7a8675c0.png)

**Reporting Steps**

1) Create a single object ticket report and add your custom ticket create date and time property to the data points

2) Display the count of tickets by the custom create date and time property

3) Export the data to Excel

**Example Ticket Report**

 ![Screenshot 2023-05-26 at 8.38.11 AM.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/0/7/079627a6e03260f7c171d792fb6ada6c688a4edb.png)

**Outcome in Excel**

 ![Screenshot 2023-05-26 at 8.38.39 AM.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/e/2/e2b207fc8a64676c1fd83e0945910acaae28fbb8.png)

**API Workaround**

Regarding the “Create Date” property, the only way to be able to format it in this way is to use the “Datetime” property which is currently limited to API calls. More about this[here](https://legacydocs.hubspot.com/docs/faq/how-should-timestamps-be-formatted-for-hubspots-apis) and [here](https://developers.hubspot.com/docs/api/faq#:~:text=Daylight%20Saving%20Time).-,Date,-and%20datetime%20properties). If you are interested in doing this via an API call, we can refer to [this documentation](https://developers.hubspot.com/docs/api/crm/properties#tab-2) for corresponding endpoints.

I hope this helps!

Best,

Kristen