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? : Portal

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? Print

Modified on: Tue, 28 Dec, 2021 at 5:00 PM

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

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

Did you find it helpful? Yes No

Help Desk Software by Freshdesk