Displaying date range in report header of crystal reports

I have a report built in Crystal Reports 11.  I would like to display the minimum and maximum dates in the report header but cannot figure how to do.  Can anyone help?
OB1CanobieAsked:
Who is Participating?
 
mlmccCommented:
Are you talking about the minimum and maximum dates in the data or in a date parameter range?

For the minimum to maximum date in the data of a particular field.

"Containing information from: " 
& totext({DateField}, 'MM/dd/yyyy')
& " to " &
totext({DateField}, 'MM/dd/yyyy')

For a parameter
"Containing information from: " 
& totext({?DateParam}, 'MM/dd/yyyy')
& " to " &
totext({?DateParam}, 'MM/dd/yyyy')

mlmcc
0
 
PCIIainCommented:
Create a formula

minimum({datefield} )

and paint it on the report header?
0
 
LinInDenverCommented:
I agree with PCI -

If you want to print something like: Containing information from: 11/30/2009 to 12/06/2009

you would do the following formula:

"Containing information from: " 
& totext({Command.START_DATE}, 'MM/dd/yyyy')
& " to " &
totext({Command.END_DATE}, 'MM/dd/yyyy')
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.