Skip to Content

Need to change the date format from MM/DD/YYYY to YYYYMMDD

Hi All,

I have a requirement in which I need to change the date format from MM/DD/YYYY to YYYYMMDD format. I checked it in control panel settings but

this setting is not available. Moreover, the Format in HANA Calcualtion view is YYYYMMDD, but when it comes to Bex it is changed to MM/DD/YYYY?

Can somebody advise me on this?

Regards,

Yash Parikh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 23, 2015 at 09:41 AM

    Hi Yash,

    If you are running the Bex report in Bex Analyzer,then it always take the date format as per client system(local running system) date format.

    You can change the date format of local running system with date format YYYYMMDD and run this report in Bex Analyzer,you can see the date as per your require format.

    Regards,

    Rajesh

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 22, 2015 at 03:03 PM

    Hi,

    The format of date is really in YYYYMMDD but you see it in the format MM/DD/YYYY because that's the configured view format on your username..

    Check your username in SU01 and find the date view format something and change it to YYYYMMDD..

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded