Question

10
Replies
5217
Views
Gayatri Member since 2015 1 post
incessant
Posted: 1 year ago
Last activity: 1 year ago
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
Close popover
Moderation Team has archived post
Posted: 1 year ago

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: 1 year ago


 


Hello Gayatri,


please find the attached screen shot , this easily converts my date format from mmddyyyy hh:mm to ddmmyyyy


 

Posted: 1 year ago

I also can not access this URL. I will notify the developers. I'll update when I have more information.

Posted: 1 year ago

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!

Posted: 1 year ago

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

Posted: 1 year ago

have you tried @DateTime.FormatDateTime(@DateTime.addToDate("<desired date>"))
Share this page LinkedIn
Copied!