Question
Unexpected Date format generated in DB records when OOTB function is used
Below is the OOTB function used
EMAIL_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?
Hi 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.
Based 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
Hi
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?
Hello
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 ?