Include "/" in number field ?

[jleboeuf]

I use a formula to include range value in my report header
to start i use the first formula and the result is
From:20010226 To:20010303

FIRST FORMULA
//"From:"+ totext(Minimum({?date de l'information}),0,"&quot+ " " +
//"To:"+ totext(Maximum({?date de l'information}),0,""

I WANT TO INCLUDE / BETWEEN year, month and day i try the second formula but i receive an error.

SECOND FORMULA
"From:"+ totext(Minimum({?date de l'information}[1-4]+"/"+{?date de l'information}[5-6]+"/"+{?date de l'information}[7-8]),0,"&quot+
"To:"+ totext(Maximum({?date de l'information}[1-4]+"/"+{?date de l'information}[5-6]+"/"+{?date de l'information}[7-8]),0,""

 

[dcm]

jleboeuf: I suggest the following:

"From:"+ totext(Minimum(Date({?date de l'information}[1-4],{?date de l'information}[5-6],{?date de l'information}[7-8]))),0,"&quot+
"To:"+ totext(Maximum(Date({?date de l'information}[1-4],{?date de l'information}[5-6],{?date de l'information}[7-8]))),0,"" David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner