Functions that can be used in PowerPrompt Script

[Firecat1970]

Hello,

I am adding a column to a report using Powerprompt and somehow I would like Date appear as MonthName, Year. e.g. 'July, 2003'

My backend DB is MSSQL2000

So I use the following :-
GetReport().AddDataItem("A new column", "MonthName([\\Table1\Date1])"

So normally I want to add the year part as well, and I try to use year() function. How can I convert the number to string?

I try
"MonthName([\\Table1\Date1]) + ', ' + number-to-string(year([\\Table1\Date1]))"

Now, powerprompt complains about number-to-string and it doesn't seem to recognise this function at all.

Any suggestion? Thanks.