We are currently using the following compute to display a date. Is there another function or a variable that can be added to this function to display in other languages.
INTMONTHYEAR is defined as int field and an example value stored in it is 20110131.
On the report it displays in English. We would like it to display in 7 other languages as well.
Thanks. LaurieThis message has been edited. Last edited by: Kerry,
March 18, 2011, 06:35 PM
FrankDutch
once you have created a smartdate format you can display that date as YYMD or MDYY or DMYY is that what you mean as languages?
your code misses the D by the way
Frank
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7
March 18, 2011, 06:53 PM
<FreSte>
Laurie,
Look for: "DATETRAN: Formatting Dates in International Formats" in the Functions manual There are loads of examples:
TABLE FILE CAR
SUM
COUNTRY NOPRINT
COMPUTE D1/DMYY = &DMYY; NOPRINT
COMPUTE EN/A25 = DATETRAN(D1 ,'(DMYY)' ,'(wrtr)' ,'EN' ,25 ,'A25') ; OVER
COMPUTE NL/A25 = DATETRAN(D1 ,'(DMYY)' ,'(wrtr)' ,'NL' ,25 ,'A25') ; OVER
COMPUTE FR/A25 = DATETRAN(D1 ,'(DMYY)' ,'(wrtr)' ,'FR' ,25 ,'A25') ; OVER
COMPUTE DE/A25 = DATETRAN(D1 ,'(DMYY)' ,'(wrtr)' ,'DE' ,25 ,'A25') ;
IF RECORDLIMIT EQ 1
END
March 20, 2011, 05:29 PM
Waz
Be wary of DATETRAN with some languages, I found some discrepancies on the translation in versions 7.6.4 and 7.6.5. Not sure about later ones.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
March 29, 2011, 05:24 PM
Laurie
We decided to use the DATETRAN function after all but currently Russian is not working correctly. There is an IBI case to fix that bug. Thanks for your suggestions.