Format Date in Drop Down
I am presenting a drop down to users in a Dashboard Widget (note: I get the same behavior presenting a drop down in the case harness, as well).
A report was created based on a Data Type called Flights, as shown in the attachment datatype.png. There is a date only field called FlightDate in the data type.
The drop down source is a report, based on the Flights data type, as shown in the attachment reportSource.png. In the report, the .FlightDate is formatted as MM/dd/yyyy (see attachment reportformat.png), and appears correctly when I run the report.
However, when I select the .FlightDate column from the report as the source of the drop down, it displays the date in a default format, and I cannot figure out how to change it (see attachment results.png). I want it to appear in MM/dd/yyyy format. Anyone have ideas?
***Edited by Moderator Marissa to update platform capability tags****
Thanks for providing the details very clearly.
The format defined in the report (ReportFormat.png) is target only for the when rendering the column in "Report Browser" or "when exporing the data to pdf or excel". The same format can not be applied when rendering the value using a different control like dropdown (results.png) though you are referring the report definition in the source of the control.
I am able to replicate the problem the same way. However, the dropdown control used in this case is a basic html control. This will show the value as is from the clipboard value as a simple text value and there is no auto generated way that we can apply special formatting techniques like we did on the column in the report definition.
So, we need to use some advanced control to achieve the desired behaivour. In this case, I recommend to choose "Autocomplete" control. This control allows the formatting on the value. Here are the screen prints.
Auto complete configuration -
Source configuration -
Format configuration :
An configuration that gets the same look and feel like dropdown adding an accordion at end of the control
The out come -
Hope this helps !
Please feel free to reply for any questions.
Keep up to date on this post and subscribe to comments
- Is it possible to extract date time fields into other format instead of Pega date format in BIX 6.3?
- how to covert julian date to normal date format for example: juliandate- 2013123 should be as 3 May, 2013 or yyyymmdd format
- String format date (DD.MM.YYYY) conversion to Date format (MM/DD/YYYY)
- Formatting GMT Date format to MM/DD/YYYY HH:MM:SS
- Date format switches from correct format to stored value