Date Field assistance (if possible)

[TechUser23]

I am having to do a Spanish and an English version of a report. I personally do not speak spanish. The client provided me the text they needed and I added that into my report ...

The only issue is this ... they want the Date field to Print as such ( Friday, August 10, 2007 ) ....

This is simple to do in the English one and looks fine ... issue is on the spanish one, its printing this in English. Is it possible to convert into spanish? Not terribly important, just looks tacky to have it all in spanish but this one field. Any help is appreciated.

 

[Madawc]

You could do it by Replace, but that would be very long-winded. Better would be to use date-parts to get the correct Spanish names. E.g.

if DatePart ("d", {date1}) = 1 then "SpanishforSunday"
else 
if DatePart ("d", {date1}) = 2 then "SpanishforMondayday"

Likewise for month:

if Month({date1}) = 1 then "SpanishforJanuary"
else 
if Month({date1}) = 2 then "SpanishforFebruart"

Get the code working and then fill in the correct Spanish names. Stitch the bits together,

@SpanishDay & ", " & @SpanishMonth & " " & ToText({date}, "MM, yyyy")

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[Madawc]

PS. It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10