text sheet object - with date expression

[#1]

hi i want to add a text sheet object with a concatenation of text and date. the date is to be returned by an expression that gets the most recent date from a field. I have created a script that works but the date format comes out in numeric format not date.

e.g. my text object script:

='Aged Debtors Report for ' & max( {1} [Sort Date])

returns

Aged Debtors Report for 40367

And it should be

Aged Debtors Report for 08/07/2010

Regards

[#2]

Hi both these expression still dont produce the disired result. Any suggestions?

[nathanfurby]

Not without looking at your qvw file

[#4]

Hi

I think this syntax will work

=date((today()) + 4,'MM/DD/YYYY')

Anders

[syed_muzammil]

The problem is that the Days Outstanding is a Field. So it is a set which cannot be evaluated with a single value . That is the reason it is not working. If you have a list box of Days Outstanding on your sheet then select a value in that list box. Then you will get the answer in the text box.

If you want to add a single value from the feild Days Outstanding then please clarify what is the value?

[nathanfurby]

You could also try creating a variable to use in the expression. Like Syed said - we would need to now what the Days Outstanding value is all about.