GAURAVBV Member since 2011 30 posts
Posted: 4 years ago
Last activity: 4 years ago

Date Format incorrectly mapped by parse xml.

Hi All,

I am facing an issue when mapping date values returned from the service to the clipboard.

The connector returns date values in the format "yyyy-mm-dd"

However, after parsing the xml rulethe date value is mapped to a clipboard property in the format "yyyymmdd". As you can see there are no hyphens seperating the days, months and years.

Can anyone please tell me as to why this might be happening.?


Also, when i try to reformat the date value myself to the format "dd-mm-yyyy" by using substring functions and then the function todate(). The date property by default displays the value 19700101 irrespective of what date value is being returned by the service.

Any thoughts on how the above change in date format can be achieved?

***Updated by Moderator: Vidyaranjan. Removed user added #helpme and Ask the Expert tags. Apologies for confusion, shouldn't have been an end-user option***

Data Integration
Moderation Team has archived post
Share this page LinkedIn