Ajesh
27th September 2019, 13:36
WebUI: 11.3.6
Toolset:10.4
I am changing the date format in a customized Report and that is being perfectly reflected in BW. I am putting the date format as "%D(%02m/%02d/%04Y)" and "%D(%02d/%02m/%04Y)" in different conditions.
But when i am checking in WebUI,i am getting a standard dd/mm/yyyy format, i am not getting the mm/dd/yyyy format at all.
On checking in infor xtreme i got this bit of information
Date and time formatting in Web UI 10.0 and later
The formatting of date and time fields in Web UI is simpler than in BW. All formatting is done based on
the Windows Date and Time settings only. The linked LN format code is not taken into account.
Date formatting uses the Windows Short Date format. These rules apply:
▪ Format d becomes dd.
▪ Format M becomes MM.
▪ Format yy becomes yyyy.
Time formatting uses the Windows Long Time format.
Note
On Linux client PCs, the local date and time conventions are used.
But i have tried changing the Windows Date format at my end and also at the Application Server end. I had changed it in "Change Date and Time Format" in Windows settings and changed but to no avail.Its showing the default DDMMYYYY Format.
Toolset:10.4
I am changing the date format in a customized Report and that is being perfectly reflected in BW. I am putting the date format as "%D(%02m/%02d/%04Y)" and "%D(%02d/%02m/%04Y)" in different conditions.
But when i am checking in WebUI,i am getting a standard dd/mm/yyyy format, i am not getting the mm/dd/yyyy format at all.
On checking in infor xtreme i got this bit of information
Date and time formatting in Web UI 10.0 and later
The formatting of date and time fields in Web UI is simpler than in BW. All formatting is done based on
the Windows Date and Time settings only. The linked LN format code is not taken into account.
Date formatting uses the Windows Short Date format. These rules apply:
▪ Format d becomes dd.
▪ Format M becomes MM.
▪ Format yy becomes yyyy.
Time formatting uses the Windows Long Time format.
Note
On Linux client PCs, the local date and time conventions are used.
But i have tried changing the Windows Date format at my end and also at the Application Server end. I had changed it in "Change Date and Time Format" in Windows settings and changed but to no avail.Its showing the default DDMMYYYY Format.