cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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)

Accepted Solutions (1)

Accepted Solutions (1)

former_member193452
Active Participant

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.

Former Member
0 Kudos

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

Answers (0)