Skip to Content

How to change calendar date format from M/d/yyyy to DD/MM/YYYY in WEB Intelligence

I am in need to select Date from prompt in report and in prompt I need to select the date from calendar. The issue is with the calendar date format by default in webi calendar date format is M/d/yyyy as in Screenshot 1 but i want the format to be DD/MM/YYYY by default.

The object defined in IDT is also in the same format i:e DD/MM/YYYY (Screenshot 2)

screenshot-1.png (3.0 kB)
screenshot-2.png (17.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 12, 2018 at 09:54 PM

    I have a couple of suggestions for you.

    1. in IDT, format the Date Objects - Right click on the object and select Create display format.

    2. in Webi the calendar picker date is managed by explicitly changing the preferences to the specified date and time format.

    Once the calendar picker is selected the sql should diplay the correct format.

    Hope that helps.

    Add comment
    10|10000 characters needed characters exceeded