on 07-02-2014 8:08 PM
Hello folks,
I am trying to enter the dates into a report header. I am limiting my report to certain dates and would like earliest and latest dates in my report header.
Here is how it looks:
All I am trying to change are the dates in the report header. Can I enter a formula which reflects the dates in my record selection?
Right now, the dates are 6/01/14 - 6/30/14. I don't want to do this manually every single time.
Any help is greatly appreciated.
Thank you!
Hi Korhan,
Create a formula with this code:
Minimum({Database_date_field}) & " - " & Maximum({Database_date_field})
Drag and drop this formula field on the Report Header.
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
if you're using a date range parameter use a formula like this to put in your header
totext(minimum({?dr})) + ' -' + totext(maximum({?dr}))
where dr is the name of your date range parameter.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.