on 02-12-2018 7:27 AM
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)
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.