Spanish date names in an English Document

[MegOBytes]

I have created a Dunning Letter in CR XI for our Spain office. The letter is in English and looks OK when i run it here in the US but when the Spain user runs it, the month names show up in Spanish. I am using the Crystal date format of DD MONTH, YYYY.

Is there a way of not converting the MONTH part of the date to a local language when a local (non-US) user runs the report?

Thanks for your help

RJ Piekos

 

[CR85user]

It would help knowing the original format of the date source.

Sample data and desired end result makes things much clearer

You could hard code the part of the date format relating to month.

//{@Monthname}
if month({table.date}) = 1 then ' January ' else
if month({table.date}) = 2 then ' February ' else
...etc

You could then call that as part of a date display formula:

//{@Displaydate}
totext(day({table.date}),0,'') + ' ' + {@Monthname} + ', ' +
totext(year({table.date}),0,'')

'J

CR8.5 / CRXI - Discovering the impossible

 

[MegOBytes]

thank you for the suggestion. the 2 dates that are affected by this are not database dates, they are 2 system dates:

CurrentDate and DataDate

i think i'll go with the if...then or maybe the select case

RJ Piekos