Replace Record Selection Formula with useful text 1

[paulharman1]

I have a report which the users (via an app) select a date range. Im trying to get that selection to display on the report.

I have added the special field 'Record Selection Formula' but that returns

{wmTransaction.RecordStatus} = 2 and{wmTransaction.FirstDate} in DateTime (2011, 02, 16, 0, 0, 0) to DateTime (2011, 02, 21, 0, 0, 0)

The date will always be 0, 0, 0 referenced (ie just the date, no time). And we dont need to know about the recordstatus. So from that text I would ideally want

"2011-02-16 to 2011-02-21"

Can anyone help please?

 

[paulharman1]

Lovely it works thank you very much. No way on earth could I have done that myself!!