# Report Definition Email Timestamps **URL:** \ **Category:** General\ **Tags:** email, reporting, 8-6-6\ **Created:** [February 8, 2024, 9:55am UTC](https://forums.pega.com/t/report-definition-email-timestamps/6055 "2024-02-08T09:55:19Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![IanKeithT16911417](https://avatars.discourse-cdn.com/v4/letter/i/22d042/32.png) [@IanKeithT16911417](https://forums.pega.com/u/IanKeithT16911417)\ **Post date:** [February 8, 2024, 9:55am UTC](https://forums.pega.com/t/report-definition-email-timestamps/6055/1 "2024-02-08T09:55:19Z")
Hi All, I’m creating a report definition that records timestamps of: 1.) When the first email from the consumer arrives. 2.) When the first reply from an agent to the consumer’s email is sent. For the first point, I’m using pxCreateDateTime to capture the timestamp of the initial incoming email. For the second point, I’m looking whether there exists a PEGA OOTB that captures the date and time of the initial response to the consumer. If not available, I’m interested in methods to include the timestamp of the initial reply in the report. Aside from these requirements, I’m also checking if there is a property/OOTB that captures the number of follow-ups made by consumer in the email. Is there a way to do it? Any insights is highly appreciated. ---
**Author:** ![MarijeSchillern](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/marijeschillern/32/23321_2.png) [@MarijeSchillern](https://forums.pega.com/u/MarijeSchillern)\ **Post date:** [February 26, 2024, 1:19pm UTC](https://forums.pega.com/t/report-definition-email-timestamps/6055/2 "2024-02-26T13:19:06Z")
@IanKeithT16911417 For the first point, you are correct in using pxCreateDateTime to capture the timestamp of the initial incoming email. For the second point, there isn’t an out-of-the-box property that captures the date and time of the initial response to the consumer. However, you could potentially use a custom property and set its value to the current date and time when the first reply is sent. As for capturing the number of follow-ups made by the consumer in the email, there isn’t an out-of-the-box property for this either. You could potentially use a custom property and increment its value each time a follow-up email is received from the consumer. Please note that these are general suggestions and the specific implementation would depend on your application’s design and requirements. ⚠ This is a GenAI-powered tool. All generated answers require validation against the provided references. [How to report the duration time from each Step within Stages?](https://support.pega.com/question/how-report-duration-time-each-step-within-stages) [Questions on Pega Customer Decision Hub (CDH) integration with Email Servic](https://support.pega.com/discussion/questions-pega-customer-decision-hub-cdh-integration-email-service-provider-esp) [how to fetch date from DateTime field in Report Defination](https://support.pega.com/question/how-fetch-date-datetime-field-report-defination) ---
**Author:** ![IanKeithT16911417](https://avatars.discourse-cdn.com/v4/letter/i/22d042/32.png) [@IanKeithT16911417](https://forums.pega.com/u/IanKeithT16911417)\ **Post date:** [March 20, 2024, 12:45pm UTC](https://forums.pega.com/t/report-definition-email-timestamps/6055/3 "2024-03-20T12:45:22Z")
Hi, the agent first reply timestamp is stored in a pxCreateDateTime property in data page D\_CorrespondenceCase and under pagelist pxResults. I plan to use declarative index to expose the embedded property for reporting purpose. Before I can use declarative index, I need to optimize the property for reporting. However, I cannot find the property in any of the following classes: **Work-Channel-Triage-Email** , **Data-Channel-Triage-Thread** , **PegaSocial-Message,** and **Work**. When I find it, I plan to right click on the property and then click optimize for reporting (similar to the attached screenshot). Am I in the right path? Is there another way on how to use the declarative index in report definition without optimizing first the property for reporting? Thank you so much. ---
**Author:** ![RameshSangili](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/rameshsangili/32/23377_2.png) [@RameshSangili](https://forums.pega.com/u/RameshSangili)\ **Post date:** [March 20, 2024, 2:03pm UTC](https://forums.pega.com/t/report-definition-email-timestamps/6055/4 "2024-03-20T14:03:21Z")
@IanKeithT16911417 Sorry, I’m confused with your response. Can you please be specific about the property for which you want to perform a declarative index? Is this property available part of your Case WorkPage? ---
**Author:** ![IanKeithT16911417](https://avatars.discourse-cdn.com/v4/letter/i/22d042/32.png) [@IanKeithT16911417](https://forums.pega.com/u/IanKeithT16911417)\ **Post date:** [April 16, 2024, 4:13pm UTC](https://forums.pega.com/t/report-definition-email-timestamps/6055/5 "2024-04-16T16:13:00Z")
Hello @RameshSangili, kindly disregard my recent post. After assessments, I found that using declarative index was not applicable for the design requirement. I have accepted the solution of Marijie for this inquiry. Thank you.