X
Icon

The 21st Minute


Blog

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


Related Posts
Give Python a Go
Mar 29 Python is considered the official programming language for non-programmers. It gives you increased flexibility and expansive access to your data. For those usin...
Unconventional Analysis
Jan 24 Data is often underutilized. The opportunity to use data analytics to gain insights, add more value and unravel opportunities are endless. We’ve rounded u...
5 Avenues for Importing Data into IDEA
Nov 21 One of the greatest benefits to CaseWare IDEA is the sheer amount of data it can read and make universally consumable – both in file types and in data...
BROWSER NOT SUPPORTED

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

×