date month in english

[rchiu5hk]

Dear all,

In the crystal report, I have the datetime field. I will make the formula field to show June-2011 in english without setting the windows locale. How can I do?? As now it is showing in chinese.

[jggtz]

You can load an array with the names of the months and use then Month function as an index to extract it...

JG

[jawadhashmi]

Did you try this ?

datetimevar date_time := PrintDate;
totext(date_time, "MMMM - yyyy");