Question4Replies1290Views×Close popoverSuman Kasanagottu (suman_sk) Accenture Application Development Senior Analyst Accenture IN View Profile suman_sk Member since 2015 1 post Accenture Posted: November 9, 2018Last activity: November 26, 2018Posted: 9 Nov 2018 13:18 ESTLast activity: 26 Nov 2018 7:17 EST 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 Experience ×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: 2 years agoPosted: 10 Nov 2018 14:43 EST×Close popoverDevarajulu Prathapaneni (Deva_Prathapaneni) Cognizant Tech Lead Cognizant SE View ProfileDeva_Prathapaneni Cognizant replied to suman_skYou can create SQL funtions and refer for property which you want to covert. Posted: 2 years agoPosted: 11 Nov 2018 6:19 EST×Close popoverRachit Agarwal (Rachit_Agarwal) PEGA Senior Technical Solutions Engineer Pegasystems Inc. IN View ProfileRachit_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: 2 years agoPosted: 11 Nov 2018 7:06 EST×Close popoverNandhadeepa Venkatesan (Nandhadeepa_V) PEGA Technical Solutions Engineer Pegasystems Inc. IN View ProfileNandhadeepa_V PEGA replied to suman_skPlease refer the below article https://community.pega.com/support/support-articles/date-time-format-not-similar-report-and-exported-excel Accepted Solution Posted: 2 years agoUpdated: 2 years agoPosted: 26 Nov 2018 1:55 ESTUpdated: 26 Nov 2018 1:54 EST×Close popoverSuman K (SumanK22) GE Healthcare GE Healthcare IN View ProfileSumanK22 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.