Skip to Content

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

Feb 12 at 07:27 AM


avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Jacqueline Rahn
Feb 12 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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thank you for your kind response. I changed the locale in the preferences and it worked.