formatting concatenated date fields on a report

[lscheer]

I have a report that I want to display "StartDate-EndDate" (two separate fields). In the underlying table, the fields are formatted with mmmm d", "yyyy so that the date reads: October 10, 2002. This is how I want the dates displayed in the concatenated field on the report, but instead it displays it in short date format (10/10/02-10/12/02). Is it possible to get the report to display the dates in the format I want (and the format they are already displayed in each separate field?

 

[cpod]

Just put this in your text box:

=format([startdate],"mmmm d, yyyy") & "-" & format([enddate],"mmmm d, yyyy")

 

[lscheer]

Wow, thanks, that was easier than I expected!