CR 8.5 Parameter field to formula 1

[3dthies]

I have a multiple value date parameter field (for example: 01/01/2002 to 12/31/2002). i want to display that value in the report. how can i do this?

Thanks for help!

 

[mbarron]

Creat this formula:
totext(minimum((?paramater}))+" to "+totext(maximum({?parameter})) Mike

 

[3dthies]

Thank you Mike this was very helpfull but i get dd/mm/yy and it should look like dd/mm/yyyy ?

 

[mbarron]

Use this one then:
totext(minimum((?paramater})},"dd/MM/yyyy&quot+" to "+totext(maximum({?parameter})},"dd/MM/yyyy&quot

The reasoning:
When using totext, it "checks" and uses the default format for the field type you are changing to a string. The defaults can be found by going to File/Options/Fields tab. You date field is probably set to dd/mm/yy
Mike

 

[3dthies]

Thanx Mike