Formatting 1

[klaidlaw]

I am using Crystal Reports 11 release 2.

I would like to make a heading that says "Gross Sales for "minimum date - maximum date" I have that set up but they way the fields are it gives the time too and I don't want that so it says right now

Gross Sales for 1/15/2009 12:00 AM - 6/30/2009 12:00 AM

I want it to look like

Gross Sales for 1/15/2009 - 6/30/2009

Currently my formula looks like this
"Gross Sales for " + totext(minimum({Table.Field})) + " - " + totext(maximum({Table.Field}))

I would appreciate any help thanks!!

 

[lbass]

Gross Sales for " + totext(minimum({Table.Field}),"M/dd/yyyy") + " - " + totext(maximum({Table.Field}),"M/dd/yyyy")

-LB