Question

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****

Correct Answer
October 9, 2019 - 3:03pm

Hi @Alan.R.Thompson,

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.

Thank you,

Regards, Cherb.

Comments

Keep up to date on this post and subscribe to comments

Pega
October 9, 2019 - 3:03pm

Hi @Alan.R.Thompson,

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.

Thank you,

Regards, Cherb.

October 10, 2019 - 10:57am
Response to cherb

Thank you for the detailed response. It was spot on, and I can confirm it behaves as you described.

Pega
October 10, 2019 - 12:05pm

I'm glad that your problem is solved. Thank you @Alan.R.Thompson