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
Tech Tip: Finding Unique Records
Jul 21 CaseWare IDEA® V11.1 gives you access to a growing library of popular audit-specific apps that make common tasks effortless. By upgrading to the latest version...
Best Kept Secrets of IDEA
Jul 20 Compare Databases   The Compare Databases task lets you identify differences in a single Numeric field within two databases (referred to as the primary a...
Taxes
Jan 01 A major area for government work is in auditing the various taxes collected at local and national level. Tests are often very specific to the departments concer...
BROWSER NOT SUPPORTED

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

×