Question
Knowledge Expert
NL
Last activity: 15 Apr 2017 14:18 EDT
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?
Pegasystems Inc.
IN
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 ?
Knowledge Expert
NL
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.
PEG
GB
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
Pegasystems Inc.
IN
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?