Audimation Services has been acquired by Caseware International Learn More.

X
Icon


Blog Image

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.


CaseWare IDEA , Tech Tip



Posted By

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.


Related Posts
Data Beware: The Auditor and the Phantom
Oct 31 One day, Jack O. Auditor found his numbers were off. He ran them again, just to make sure. The same numbers! How can that be? Jack goes to see his boss. “I...
Using Editable Fields in IDEA
Feb 27 One of the best features in IDEA is that the data you import is record-locked. In other words, you cannot accidentally overtype the source data. Sometimes, say ...
Using IDEA to Convert CRM Data
Mar 14 We use IDEA to assist our customers with complex import projects, analysis projects, and development of customized IDEAScripts. We also use IDEA for ourselves a...
BROWSER NOT SUPPORTED

This website has been designed for modern browsers. Please update. Update my browser now

×