Date formatting issues in report displayed with ePortfolio

[Baah]

Hi, I developed a report using Crystal 9.0 and have published it to the enterprise server using the publishing wizard. All date related data in the report are actually stored as a date-time field in the oracle database but since I dont want them to be displayed as date-time and (for doing calculations on these fields as well) I use the following formula:

MonthName(Month(DateValue({Command.CREATED})),TRUE) + " " + ToText(Left(TOTEXT(YEAR(DATE({Command.CREATED}))),4))

I want the result to be like 'Jan 2003' or 'Feb 2003' etc..I get this format when i preview the report from within Crystal but when I launch this report using ePortfolio i get the values as 'Jan 2,00' or 'Feb 2,00'...Obviously this seems to be formatting issues but I'm at my wits end on identifying what's causing this problem...Please help...

TIA

 

[Baah]

Hi All,

It's extremely embarrasing but I found that if I just use CSTR without resorting to the extremely complicated function, I can achieve the desired result...here's the solution..

Cstr({Command.CREATED},'MMM yyyy')

Due apologies...I should have taken that extra 10 mts and a coffee before I posted this...thanks to all who were working on helping me out...