Question

10
Replies
6850
Views
 Gayatri Nistala (Gayatri)
incessant

incessant
IN
Gayatri Member since 2015 1 post
incessant
Posted: February 25, 2019
Last activity: October 3, 2019
Posted: 25 Feb 2019 5:07 EST
Last activity: 3 Oct 2019 13:33 EDT
Closed

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****

Data Integration Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 2 years ago
Posted: 25 Feb 2019 23:49 EST
Gayatri Nistala (Gayatri)
incessant

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.
Posted: 2 years ago
Posted: 8 Mar 2019 10:43 EST
Gopesh Saha (GOPESH SAHA)
Cognizant Technology Solutions
Senior Pega - Developer
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