|
Rank: Member
Joined: 7/23/2018 Posts: 11 Location: London
|
Hi I am trying to convert a excel date field into xml date format
My excel date field something like this = 2019/05/31
.Xml (.xsd) display format should be like = 2019-05-31
really appreciate your thoughts on this
many thanks
File Attachment(s): Doc1.docx (66kb) downloaded 232 time(s). Doc2.docx (99kb) downloaded 244 time(s).
|
|
Rank: Advanced Member
Joined: 12/13/2005 Posts: 2,856 Location: Mauritius
|
What about simply using the replace function to replace / with -
|
|
Rank: Member
Joined: 7/23/2018 Posts: 11 Location: London
|
Hi Many thanks for your reply
I have tried that way I get the error as follows
Conversion to date failed for '2019-08-08T16:24:31.906+01:00'
I have attached the screen shot of my mapping for your attention
kind regards sharma
|
|
Rank: Member
Joined: 6/4/2019 Posts: 13 Location: Trieste
|
Hi, I Have the same problem, did you figure out how to resolve the problem ?
|
|
Rank: Advanced Member
Joined: 2/27/2009 Posts: 558
|
His string is clearly a datetime, not a date, so use date-from-datetime.
|
|
guest |