# Modifying date values for daily reports

**URL:** <https://community.hubspot.com/t/modifying-date-values-for-daily-reports/74992>\
**Category:** Reporting & Analytics\
**Tags:** enterprise\
**Created:** [February 10, 2023, 8:27pm UTC](https://community.hubspot.com/t/modifying-date-values-for-daily-reports/74992 "2023-02-10T20:27:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ABergunder](https://avatars.discourse-cdn.com/v4/letter/a/b4bc9f/32.png) [@ABergunder](https://community.hubspot.com/u/ABergunder)\
**Post date:** [February 10, 2023, 8:27pm UTC](https://community.hubspot.com/t/modifying-date-values-for-daily-reports/74992/1 "2023-02-10T20:27:27Z")

</div>

My team sends out automated daily reports on the previous day’s sales metrics to members of our organization. I’d like to give these reports an accurate date stamp as opposed to the current language we’re using of “yesterday.”

Could I use something like **content.publish\_date** or **content.updated** and subtract a day from that value to get a more detailed display of yesterday’s date within the email?

Thanks for any insights!

---

<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:** [February 13, 2023, 12:25pm UTC](https://community.hubspot.com/t/modifying-date-values-for-daily-reports/74992/2 "2023-02-13T12:25:45Z")

</div>

Hi @ABergunder,

Thanks for reaching out to the Community!

Which HubSpot tool do you use to create these reports? Do you have screenshots of the current report filters?

The more examples you can share of what your current reporting filters look like and your desired outcome, the better the community can assist with the next steps 🙂

Thank you!

Best,

Kristen

---

<div class="post-metadata">

**Author:** ![ABergunder](https://avatars.discourse-cdn.com/v4/letter/a/b4bc9f/32.png) [@ABergunder](https://community.hubspot.com/u/ABergunder)\
**Post date:** [February 13, 2023, 11:28pm UTC](https://community.hubspot.com/t/modifying-date-values-for-daily-reports/74992/3 "2023-02-13T23:28:20Z")

</div>

Thanks for the reply Kristen!  
The majority of the data that’s included in the reports comes from other external systems, so we pass things into HubSpot through the API and then reflect them in the emails with some custom tokens.  
But to avoid packing more variables than we need into that API data, it would be great to use HubSpot’s own datetime tokens for the date portion, and then modify that to display the day prior to the email’s send date.  
So something along the lines of

`{{ content.publish_date - [1 day] | format_date ('long') }}`

is what I’ve had in mind, but obviously isn’t quite right.

Thanks