Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Text Box to Show Date Range

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Maybe something like

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

resp.

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

View solution in original post

1 Reply
swuehl
MVP
MVP

Maybe something like

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

resp.

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