Barcode Fonts, Components, ActiveX and .NET Windows Forms Controls, Java Servlets, 
DLLs and Barcode Scanners. IDAutomation.com, Inc., Computers Hardware, Software & Services, Tampa, FL   This site chose the Norton Secured Seal to promote trust online with consumers.    View your cart in the IDAutomation Store   


How to Format Dates from CSV Files

A problem may occur when using CSV files in any format other than mm/dd/yyyy. This issue may occur in the Barcode Label Software.

Problem:

When linking with an external CSV file, if the file contains a date in any format other than mm/dd/yyyy, the label making software will automatically convert the date to that format. This problem is especially troublesome for users in countries where the date format is often dd/mm/yyyy.

CSV and text files do not associate data types to fields. The ADO.Net component used in the IDAutomation Barcode Label Software will automatically set the field type based on the contents of the data. This component works independent of the regional settings of the operating system.

Solution:

In the CSV file, place the data in quotes that is not to be formatted automatically in the ADO.Net component, for example "dd/mm/yyyy". This will force the data to be imported as a string type and the ADO.Net component will not attempt to reformat it.

NOTE: The limitation of the ADO.Net component has no effect when linking to files that store data type information, i.e. Microsoft Excel® or Access®.

Related Documents:
 ©Copyright 2017 IDAutomation.com, All Rights Reserved. Legal Notices.

 Barcode Fonts | Components | Scanners | Support | Contact Us

Training Videos on YouTube  Join us on Google Plus  Join us on LinkedIn  Follow us on Twitter  Like us on Facebook
Over 70% of Fortune 100 companies use IDAutomation's products to automate their businesses.