Hi,
I need to display international date format in excel. Can someone you please provide some samples to achieve.

Thanks & Regards
Padmavathy Soorian

This message has been edited. Last edited by: <Emily McAllister>,

can you share few example of international formats.

Hi Ram,
we have tried the below.But it was not working out.

SET DATETIME ON
-SET &DAYIN = '20070523';
DEFINE FILE CAR
DATEIN/YYMD = &DAYIN;
END

TABLE FILE CAR
PRINT DATEIN
BY MODEL
ON TABLE SET EXL2KLANG JPN
ON TABLE PCHOLD FORMAT EXL2K
END

Sample result:

MODEL Actual Date format Expected result
100 LS 2 DOOR AUTO 2007/05/23 2007年5月23日

What is international date?


IF you have $97 to spend, take a loot at http://www.aviter.com/keysheet/home/dates-book/

I have tried changing the excel language settings , browser settings , system settings to Japanese.
Even then it was not working.

Thanks & Regards
Padmavathy Soorian

For instance , I need to generate excel in Japanese date format.

2007/05/23 date should be in 2007年5月23日 format in excel.

I haven't modified my nlscfg file but wonder if this is the issue. According the doc:

When included in the nlscfg.err file, the EXL2KLANG parameter specifies the language used for Microsoft® Excel requests. This language must be the same as the language of Excel on the browser machine in order to correctly display output.