Date "Conversion Error" when importing an Excel spreadsheet
Cédric BLANC
started a topic
over 3 years ago
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
C
Cédric BLANC
said
over 3 years ago
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
Cédric BLANC
said
over 3 years ago
Answer
You can use simple excel formula to convert date column to what Semarchy Date Type formatting is accepting:
Cédric BLANC
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?
You can use simple excel formula to convert date column to what Semarchy Date Type formatting is accepting:
Cédric BLANC
You can use simple excel formula to convert date column to what Semarchy Date Type formatting is accepting:
-
Extend a model with new entities or attributes
-
Data types in xDM
-
Effective date on entities
-
Search using wild cards
-
Export a model from production and import on a development environment
-
"Allow Delete" vs "Allow Removal" privileges
-
LOV label in Named Query
-
Select location on a map and save coordinates
-
Is there a way to set up a master-detail relationship on browse mode?
-
Choose Either a Stepper or A Workflow Based on The User Privileges
See all 318 topics