Date Fields Importing into IDEA as Character Type Fields
Tech Tip to Help Format Your Data
Why are my date fields importing into IDEA as character type fields?
If you are importing from Excel, the date column needs to be formatted as a date type in Excel. You also need to check the box to Import empty numeric cells as 0 during the import into IDEA. If that does not work, save the Excel file as CSV (Comma delimited)(*.csv). Then use the Text import option in IDEA to import the .csv file. During the import process, be sure you define the date information as a date field type.
If you are importing your data from Access, the date field data type needs to be formatted as a date/time field before you import.
If you are importing a PDF or print report, be sure you define the date information in the Properties window as a date field type.
By Kris Willison Kris joined the Professional Services team in January of 2015 as a Solutions Specialist. She has an extensive background in Software and Database Development accumulated from thirty years in IT support with twenty years’ experience in database development, cleanup, audit and migration using Microsoft Access. In her time with Audimation, she has received client praise for her “Top Tier” engagement on Monitor and Scripting projects. Kris enjoys looking at problems from new angles to determine the most efficient means of meeting the clients’ needs. Kris has been breeding/showing purebred Balinese cats since 1972 and Oriental Longhairs since 1996. She also hosts one of the largest online pedigree database sites for Siamese and related breeds with nearly 600 users worldwide.