Question
Nike USA Inc
IN
Last activity: 2 Nov 2018 7:53 EDT
How to covert date format MMM dd hh mm ss yyyy to yyyy-mm-dd
Hi All,
Can any one suggest an approach to convert date format from MMM dd:hh:mm:ss yyyy to yyyy-mm-dd.
Regards,
Ramprasad
***Updated by moderator: Lochan to update Categories***
Pegasystems Inc.
GB
Hi Ramprasad,
If it is valid for you to look at the problem in a different way : you are basically processing Strings here - you should be just be able to re-arrange your first string to get the second string using a PRPC Function (which you will write yourself in Java).*
Can you just clarify with concrete examples though: I'm a little confused about the meaning of 'mm' here (it looks like minutes in the first example, but then looks like months in the second ) ?
*It might NOT be valid to do this: since you *might* (for all I know) need to take into account timezones when you convert...this always adds complications and can lead to confusing results.
Nike USA Inc
IN
Hi John
Thanks for the reply.
I am using email listioner to read messages and using pydate property to identify email received date to build some logic.
I can see the below date format in pydate property(OOTB) which i want to convert to yyyy-mm-dd to validate any cases created alredy with in the date range that is from email received date and case creation date.
Dec 01 06:53:14 2017
Any suggestions on this is much appreciated.
Regards,
Ramprasad
Boeing Employees Credit Union
US
Hi Ramprasad,
We had the exact same issue. We have an email listener and we need to map the Date header to a property in Pega. The format is like this
"Date: Thu, 27 Jul 2017 14:05:04 -0700"
However, email dates formats are not compatible to Pega Date types.
I created an activity to convert from Email Date format to Pega Date format.
Also, remember to map the Email Date header to .pyInboundEmail.pyDate inside your Service Email rule.
For more information on date formating, read:
https://docs.oracle.com/javase/1.5.0/docs/api/java/text/SimpleDateFormat.html
Hope it helps!
Synechron
IN
use your dateproperty instead of currentdatetime :
@DateTime.FormatDateTime(@DateTime.CurrentDateTime(),"yyyy-MM-dd","","")
Also note :
mm=minutes
MM=Month
Nike USA Inc
IN
Thanks Sushil for your reply.
I have tried with your suggestion and it returs null value.
Please see the below for configuration.
result as null value in the below screen shot.
Please correct me if am doing any wrong here.
Regards,
Ramprasad