--- title: Tips - How to Date Stamp your Report description: Tips - How to date stamp your report when using automated time periods. --- [Skip to content](https://fundamentals.theretailscore.com/knowledge/how-to-date-stamp-your-report#main-content) English Show submenu for translations [Customer portal](https://fundamentals.theretailscore.com/support-client-view?hsLang=en) ![mousemat.png\]](https://fundamentals.theretailscore.com/hs-fs/hubfs/mousemat.png?height=40&name=mousemat.png) Open main navigation Close main navigation - English Show submenu for translations - [Customer portal](https://fundamentals.theretailscore.com/support-client-view) - Go to theretailscore.com Go to theretailscore.com The Retail Score Fundamentals - There are no suggestions because the search field is empty. 1. [TRS Fundamentals](https://fundamentals.theretailscore.com/knowledge?hsLang=en) 2. [tRS Pivot4Power Users](https://fundamentals.theretailscore.com/knowledge/trs-pivot4power-users?hsLang=en) 3. [02 How To Guide](https://fundamentals.theretailscore.com/knowledge/trs-pivot4power-users?hsLang=en#02-how-to-guide) # Tips - How to Date Stamp your Report ## Tips - How to date stamp your report when using automated time periods. When using the automated time periods, no date is visible within the filter selections. We recommend that you add in a time stamp to give your report context to the relevant calendar time as it rolls over with each refresh. ### Follow these steps to add in a time stamp to your report: - Start with your report which uses the calendar and relative period to create an automated time period (xx click link to on how to use automated time periods). This may look something like this: ![](https://fundamentals.theretailscore.com/hubfs/image-png-Sep-14-2021-07-07-33-40-AM.png) - add another tab in your report and call it "ref tab" ![](https://fundamentals.theretailscore.com/hubfs/image-png-Sep-14-2021-07-08-44-30-AM.png) - set up another pivot using the same relative period selection used in the original report pivot ![](https://fundamentals.theretailscore.com/hs-fs/hubfs/image-png-Sep-14-2021-07-10-50-93-AM.png?width=296&name=image-png-Sep-14-2021-07-10-50-93-AM.png) - go to Calendar | more fields ![](https://fundamentals.theretailscore.com/hs-fs/hubfs/image-png-Sep-14-2021-07-13-24-30-AM.png?width=195&name=image-png-Sep-14-2021-07-13-24-30-AM.png) - select the 'more fields' options you'd like to include in your report ![](https://fundamentals.theretailscore.com/hubfs/image-png-Sep-14-2021-07-16-55-45-AM.png) - Link the desired fields into the report through a concatenation formula to date stamp the report when it is refreshed. ![](https://fundamentals.theretailscore.com/hubfs/image-png-Sep-14-2021-07-27-10-42-AM.png) - you may then choose to hide the 'ref tab' tab - ensure you 'Refresh All' to ensure all connections are refreshed in the case that the ref tab connection is different to the report connection. See xx video link for demonstration on how to date stamp your report - [tRS Set Up](https://fundamentals.theretailscore.com/knowledge/trs-set-up?hsLang=en#main-content) - [01 Getting Started](https://fundamentals.theretailscore.com/knowledge/trs-set-up?hsLang=en#01-getting-started) - [02 How to Guide](https://fundamentals.theretailscore.com/knowledge/trs-set-up?hsLang=en#02-how-to-guide) - [03 Get Help](https://fundamentals.theretailscore.com/knowledge/trs-set-up?hsLang=en#03-get-help) - [tRS Insights Portal](https://fundamentals.theretailscore.com/knowledge/trs-insights-portal?hsLang=en#main-content) - [01 Getting Started](https://fundamentals.theretailscore.com/knowledge/trs-insights-portal?hsLang=en#01-getting-started) - [02 How To Guides](https://fundamentals.theretailscore.com/knowledge/trs-insights-portal?hsLang=en#02-how-to-guides) - [tRS Pivot4Power Users](https://fundamentals.theretailscore.com/knowledge/trs-pivot4power-users?hsLang=en#main-content) - [02 How To Guide](https://fundamentals.theretailscore.com/knowledge/trs-pivot4power-users?hsLang=en#02-how-to-guide) - [03 Get Help](https://fundamentals.theretailscore.com/knowledge/trs-pivot4power-users?hsLang=en#03-get-help) - [tRS Modules](https://fundamentals.theretailscore.com/knowledge/trs-modules?hsLang=en#main-content) - [01 General Ledger](https://fundamentals.theretailscore.com/knowledge/trs-modules?hsLang=en#01-general-ledger) - [02 Traffic Counters](https://fundamentals.theretailscore.com/knowledge/trs-modules?hsLang=en#02-traffic-counters) - [04 Google Analytics](https://fundamentals.theretailscore.com/knowledge/trs-modules?hsLang=en#04-google-analytics) - [tRS Admin](https://fundamentals.theretailscore.com/knowledge/trs-admin?hsLang=en#main-content) - [01 Getting Started](https://fundamentals.theretailscore.com/knowledge/trs-admin?hsLang=en#01-getting-started) - [02 How To Guide](https://fundamentals.theretailscore.com/knowledge/trs-admin?hsLang=en#02-how-to-guide) - [03 Get Help](https://fundamentals.theretailscore.com/knowledge/trs-admin?hsLang=en#03-get-help) - [tRS Case Studies](https://fundamentals.theretailscore.com/knowledge/trs-case-studies?hsLang=en#main-content) - [01 Analysis](https://fundamentals.theretailscore.com/knowledge/trs-case-studies?hsLang=en#01-analysis) - [tRS Archive Library](https://fundamentals.theretailscore.com/knowledge/trs-archive-library?hsLang=en) - [tRS Development Release Notes](https://fundamentals.theretailscore.com/knowledge/trs-development-release-notes?hsLang=en#main-content) - [Releases](https://fundamentals.theretailscore.com/knowledge/trs-development-release-notes?hsLang=en#releases) - [tRS Connect](https://fundamentals.theretailscore.com/knowledge/trs-connect?hsLang=en#main-content) - [01 About](https://fundamentals.theretailscore.com/knowledge/trs-connect?hsLang=en#01-about) - [02 Set Up](https://fundamentals.theretailscore.com/knowledge/trs-connect?hsLang=en#02-set-up) - [03 Getting Started](https://fundamentals.theretailscore.com/knowledge/trs-connect?hsLang=en#03-getting-started) - [tRS Planner](https://fundamentals.theretailscore.com/knowledge/trs-planner?hsLang=en) [![Chill listening crop-3](https://fundamentals.theretailscore.com/hs-fs/hubfs/tRS1-2.png?width=102&height=55&name=tRS1-2.png "Chill listening crop-3")](http://theretailscore.com?hsLang=en) theretailscore.com Help Center Copyright © 2026, the Retail Score