data format change in bex

[Former Member]

hi friends,

i have 0date infoobject as one of the fields in a cube. data is uploaded into cube correctly. when i checked data in cube it's in correct format 20.12.2006, but when i checked in bex report it shows 12/20/2006. how to convert it into dd/mm/yyyy or simply day first,month second and year third component format. where i have to routine? suggestion pls..

thanks,

raju

[former_member194802 · Accepted solution]

Hi Raju,

The regional settings mentioned in your system been used by Bex Analyzer.

try to change the Date format in regional setting from windows -> control pannel-> regional settings

this will definately solve your Date format issue.

Regards

Vivek Tripathi

[Former Member · Accepted solution]

thanks for ur replies..