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
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...
Tech Tip: Scheduling Scripts in IDEA V11.1
Mar 25 The Schedule feature, included in IDEA V11.1, lets you configure scripts located in the Macros Library Group (in the Current Project Library) to run on a set sc...
Exporting Data from 3 Commonly Used Applications
Jun 16 Before any work can be done in IDEA, you’ll first need to acquire the data to be analyzed. Here are the steps to export data from three commonly used a...
BROWSER NOT SUPPORTED

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

×