Text Box to Show Date Range

[#1]

Hello,

I have a Date Range I would like to show in a text box that updates when new data comes in and the dashboard is refreshed. I currently have a field called 'Date' and I would like to show in the text box the date range the other dashboard elements are displaying.

For example, I have a Gauge showing a % change Week over Week for the number of Incidents submitted. I would like two text boxes showing:

1. Current Week Date Range

2. Prior Week Date Range

[swuehl · Accepted solution]

Maybe something like

=Weekstart(Today()) & ' - ' &Weekend(Today())

resp.

=Weekstart(Today(), -1) & ' - ' &Weekend(Today(), -1 )