Can my user input date filters be populated with a dynamic default date
11 June, 2013
Hi There,
Is there a way to populate user input filters dynamically each time the report is run.
For example, we have two date filters:
- Start Date
- End Date
When the user runs the report, we would like the end date to default to the current date/time and the start date to default to the end date - 1 year.
The users will then input their own date ranges.
Thanks in advance!
Is there a way to populate user input filters dynamically each time the report is run.
For example, we have two date filters:
- Start Date
- End Date
When the user runs the report, we would like the end date to default to the current date/time and the start date to default to the end date - 1 year.
The users will then input their own date ranges.
Thanks in advance!
When you preview the report you go to the Filters menu and select each filter name. You then have the ability to set a default (Current Date +/- x Days, Weeks, Months, Qtrs, Yrs).
Thank you for responding.
We are using version 6.2 of the software. These are the options I have available:
We are using version 6.2 of the software. These are the options I have available:
Hi,
It's happening because you're dealing with TIMESTAMP data type. If you want to be able to set your Date Filter to Current Date +/- X days/weeks/months - you have to format your Date Filed from TIMESTAMP to DATE. In order to do so
- go to your view
- put your date field into edit mode
- click on Format Tab and select 'Date' as a desirable format
after that you'll be able to set up default values for your filters based on the current date.
Hope it helps.
Jenny.
It's happening because you're dealing with TIMESTAMP data type. If you want to be able to set your Date Filter to Current Date +/- X days/weeks/months - you have to format your Date Filed from TIMESTAMP to DATE. In order to do so
- go to your view
- put your date field into edit mode
- click on Format Tab and select 'Date' as a desirable format
after that you'll be able to set up default values for your filters based on the current date.
Hope it helps.
Jenny.