Start a new topic
Answered

Date "Conversion Error" when importing an Excel spreadsheet

When I try to import an Excel spreadsheet in the front-end application, xDM shows me an error that says "Conversion Error" for a few date fields. How do I resolve this error so I import a spreadsheet with date columns?


Best Answer

You can use simple excel formula to convert date column to what Semarchy Date Type formatting is accepting: 

=TEXT(A1,"MMM DD, YYYY")
1 Comment

Answer

You can use simple excel formula to convert date column to what Semarchy Date Type formatting is accepting: 

=TEXT(A1,"MMM DD, YYYY")
Login to post a comment