Need help with dates

[QueSpr04]

I am using CR10 and ODBC [RDO] connection. However, I have a field in the report called e_date that is used to show the date selected for the report. This is not a parameter, but just a date field that is coming down from the data in the database. The initial problem that I had was getting the report to show dates that started on the weekends, such as Saturday May 1, 2004. And the formula that I used to correct the problem was,
dateserial(year({tablename.e_date}),month({tablename.e_date}),1) for the begining date and dateserial(year({tablename.e_date}),month({tablename.e_date})+1,1-1)
for the last date. However, this formula only works for selecting an entire month. I want to be able to display the date if the report is selected for only one day. For example, this is the way the report appears...

Report Totals for: Saturday, May 1, 2004 To Monday, May 31, 2004

This is when the report is selected to run for the entire month. But when the report is selected to run for just one day, it should appear as such...

Report Totals for: Monday, May 31, 2004 To Monday, May 31, 2004

How can I get the program to display only one day?

 

[synapsevampire]

I answered your other post...