Question4Replies1197Views suman_sk Member since 2015 1 post Accenture Posted: 1 year agoLast activity: 1 year 9 months ago Closed Solved How to retrieve the datetime to date format 9th Nov 2018 in a report.fetching the DateTime property from work table into a report definition and these values are being appended in a excel sheet , where we see these values in format like '20181109121230023 GMT'but we are in need to get these values to be dispalyed in the excel as 09th Nov 2018.Please suggest your Ideas on this ...***Edited by Moderator Marissa to update platform capability tags**** Reporting User Interface ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 1 year agoDeva_Prathapaneni Cognizant replied to suman_skYou can create SQL funtions and refer for property which you want to covert. Posted: 1 year agoRachit_Agarwal PEGA replied to suman_skPlease refer to below post https://community1.pega.com/community/product-support/question/date-format-showing-incorrect-format-excel-file-pegas-export Posted: 1 year agoNandhadeepa_V PEGA replied to suman_skPlease refer the below article https://community.pega.com/support/support-articles/date-time-format-no… Accepted Solution Posted: 1 year agoUpdated: 1 year agoSumanK22 GE Healthcare replied to suman_skThanks All for your suggestions and comments, i was able to fulfill this requirement creating a function alias to convert the datetime to required format as text.