Date Format Convertion in Bex.

[Former Member]

Hi All,

I have one Requirement in Data Format conversition in BEx,

at present the data is diaplaying as MMDDYYYY , but the user wants its to be diplayed as ddmmmyyyy.

can any one help me how to convert data form mmddyyyy to ddmmmyyyy .

Thanks in Advance.

Regards,

sandeep.

[Former Member]

Hi santosh kumar ,

Use this code

SimpleDateFormat fSDateFormat = new SimpleDateFormat(dd/mmmyyyy");

Date now = new Date();

String date_out = fSDateFormat.format(now);

Regards,

P.Manivannan

[Former Member]

Hi manivannan,

Thanks for the replay,

Could u please tell me the path, where can i write this Code, to convert date format.

Regards,

sandeep.

[Former Member]

Hi,

Are you using a field based on Dictionary? if yes you can set "External Representation Fields", format field.

http://help.sap.com/saphelp_nw04/helpdata/en/99/28c30af89be54088286cb3e06672fc/frameset.htm

Regards

[Former Member]

Hi All,

Problem is resolved.We need to change the user settings.

Thanks and regards,

santosh

[Former Member]

resolved