String(MM/DD/YYYY) to Date conversion
Hi All,
I have to convert date string which is in MM/DD/YYYY format to Date .
I have tried below functions but nothing worked for me.
- To Date
- FormatDate
- String to date
Even i tried to swap date and time by using What comes function then after i used above functions, it worked when i ran the activity from clipboad, but when it is executing from service(Service Soap) activity it is throwing exception string cannot be date.
Any help would be much appreciated.
***Edited by Moderator Marissa to update platform capability tags****
Pegasystems Inc.
IN
Hi,
Please check below discussion should help you out
https://community1.pega.com/community/pega-support/question/how-convert-ddmmyyyy-format-string-date
Thank You
incessant
IN
Hi Sekhar,
above thread is differant from my issue.
i am getting date value as 02/14/2019 12:32:29 PM, so here issue is format what i am getting is MMDDYYYY with timestamp.
if we can swap date and month it will work, but from soap service if we using this logic we are getting exceptions.
Flextronics
IN
Hello Gayatri,
please find the attached screen shot , this easily converts my date format from mmddyyyy hh:mm to ddmmyyyy
Raytheon
US
The above link is not working.
Pegasystems Inc.
US
Hi YashK026,
The link works for me. Please try again.
https://community1.pega.com/community/pega-support/question/how-convert-ddmmyyyy-format-string-date
Raytheon
US
https://community1.pega.com/community/pega-support/question/how-convert-ddmmyyyy-format-string-date
I believe the Pega Community site is having issues and I still cant access the link (see attached).
Can someone post the solution on this thread please?
How to convert String dd/mm/yyyy to Date type?
Pegasystems Inc.
US
I also can not access this URL. I will notify the developers. I'll update when I have more information.
Pegasystems Inc.
US
Hey @YashK026!
I'm now showing that this URL is working now for you. Please let us know if you have any trouble accessing it.
Thanks for letting us know!
Cognizant Technology Solutions
GB
Hi Gayatri,
Have you tried to trace this? Might be something changed during the Service Soap run?
If you are not getting the root cause after tracing, please share the screen shot how you have setup, will try to help you find the issue.
Thanks!
Gopesh
COFORGE DPA
AU
have you tried @DateTime.FormatDateTime(@DateTime.addToDate("<desired date>"))