Question

Date format in Table layout

Hi,

PFA document, I would like to display dataformat as MM/DD/YYYY HRS:MINS format by selecting Date/Time option in presentation tab of Table Layout. But is displaying as MM/DD/YYYY only.

But in Dynamic layouts it is getting displayed as expected I.E MM/DD/YYYY HRS:MINS for example 01/30/2020 7:00 PM.

Please help me fixing this.

Regards,
Surya Y V

Comments

Keep up to date on this post and subscribe to comments

Pega
December 10, 2019 - 7:20am

Hi Surya,

Can you check the source of the table?If the source of the table is report definition and check any column format is applied to the date field.

 

December 10, 2019 - 7:31am
Response to bogap

Thanks @bogap for the quick reply.

No, it is not report definition. Source is Property of type PageList.

Regards,
Surya Y V

December 10, 2019 - 7:52am

Hi Surya,

Could you please check the property value in clipboard if it is not correct then  give a try by providing the control format as pxdatetime on property field.

Thanks,
Gopi

December 11, 2019 - 12:27am
Response to Gopinath.A

Hi @Gopinath.A,

 In clip board also it is displaying in only MM/DD/YYYY format post changes in presentation tab of that particular property. Also Property type is Datetime with UICotrol pxDatetime value.

Regards,

Surya Y V

Pega
December 10, 2019 - 11:45am

Hi Surya,

Could you please ensure whether the Display value using read-only formatting checkbox is enabled in the Presentation tab of the DateTime (Cell Properties).

Thanks,

Geeda.

December 11, 2019 - 12:31am
Response to GeedA

Hi @GeedA

 In presentaion tab we are using Edit option as Read-only(always).

 For Edit options Auto only we are able to select the option mentioned by you above. PFB image.

Pega
December 11, 2019 - 9:00am
Response to SuryaYanamandra

Hi Surya,

I have tried with Edit option as Read-only(always) in the presentation tab of DateTime Property and it is working fine at my end. I checked in 8.1.6 environment. Could you please provide your Pega product version? Also, ensure that the Property is of "DateTime" format and the control used in the section is OOTB "DateTime" control.

Thanks,

December 13, 2019 - 1:22am
Response to GeedA

Hi @GeedA,

We are using 7.3. 

Regards,

Surya Y V