Question
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****
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.
Hello Gayatri,
please find the attached screen shot , this easily converts my date format from mmddyyyy hh:mm to ddmmyyyy
Hi YashK026,
The link works for me. Please try again.
https://community1.pega.com/community/pega-support/question/how-convert-ddmmyyyy-format-string-date
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?
I also can not access this URL. I will notify the developers. I'll update when I have more information.
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!
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
have you tried @DateTime.FormatDateTime(@DateTime.addToDate("<desired date>"))
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