Question4Replies145Views PriyankaKN Member since 2014 12 posts Accenture , Netherlands Posted: 3 years agoLast activity: 3 years 5 months ago Closed Unexpected Date format generated in DB records when OOTB function is usedBelow is the OOTB function usedEMAIL_SENTDATETIME = @(Pega-RULES:DateTime).FormatDateTime(@(Pega-RULES:DateTime).CurrentDateTime(), "d-MMM-yyyy HH:mm:ss", "America/New_York", "")Issue Faced : We are seeing records for DB in Column EMAIL_SENTDATETIME as "11-abr -2017" instead of "11-Apr-2017"Any suggestions regarding why "11-abr-2017" is getting recorded in DB? Data Integration ×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: 3 years agoSantanu PEGA replied to PriyankaKNHello At my end I cant see the issue happening in my 7.2.2 system. Attached the image. Have you tried running tracer and see whether any error coming there or not? Also what is your system locale ? Posted: 3 years agoPriyankaKN Accenture , Netherlands replied to SantanuHi Santanu , Thanks for your reply We are currently using 6.3 SP1 and that issue is not very persistent , it is only occuring for very few records( as of now for 4 records) in Production and it is working fine in rest other environments. Posted: 3 years agoLaurenceB_GCS PEGA replied to PriyankaKNBased on the characters alone I'd be inclined to try testing this with an operator who is logged in with a Spanish locale, and see whether you then reproduce the same behaviour more consistently. If so, you may choose to specify the locale when you make the call to FormatDateTime Posted: 3 years agoSantanu PEGA replied to PriyankaKNHi Even I also suspect some locale related stuff here. Which locale your users are using when they are facing the issue and also what is the browser locale?