Show Date Range

[hgg21]

Greetings,

I have specified in the select expert for one of my fields {Trade.TradeDate} to be between some dates.

Now if I want to display the date ranges in the report?
How can I do it?
For example:
TradeDate: DDMMYYYY to DDMMYYYY

Thanks for any advice.
Regards
Jerry

 

[hgg21]

I have managed to solve the above problem.

However now I need to format the date.

Now the format of my date is something like:
12/27/01 12:00:00AM to 04/24/02 12:00:00AM

How can I change it to something like:
mm/dd/yyyy to mm/dd/yyyy?

Thanks!
Jerry

 

[synapsevampire]

If you're converting the date using totext, add in the formatting:

totext({MyTable.MyDate}, 'MM/dd/yy') + ' to ' + (... the other date)

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com