Detailed Field Information Related Information Examples & Tutorials

Import Date Options

This form defines the format of date fields. Choose from the available formats. You do not need to fill this in if you are using the default format of MM/DD/YY. This setting applies to all dates imported from the incoming file.

tip.gif If you import or export a file with multiple date formats, you will need to press the Date Options button on the Import Field Specification form for individual fields. This will bring up the Import Field Date Format dialog where you can set the format for a particular date field.

Please bear in mind that what you see in a spreadsheet may not be the actual layout of your dates. To see the actual layout, open your file in a text editor, such as Notepad.

When you have determined the actual layout of the dates that you are importing, select the option below that matches your file's date format.

Dates will be converted into the Collect! internal date format as they are imported. Then they will be displayed correctly in accounts, contacts, transactions etc. However, they must be read correctly from the file as the import is being run, so your choices below must accurately reflect the format of the date as it appears in the file you are importing.

By default, dates are MM/DD/YY.

MDY - Month/Day/Year

Radio button: MDY - Month/ Day/Year
This is MonthDayYear

If you determine that the actual layout of the dates give n in the imported file is in the format MDY,

For example:
Date: April 9, 2001
Formatted as 04/09/2001 04/09/01 04092001

Then select the MDY - Month/Day/Year radio button.

Top of page.

YMD - Year/Month/Day

Radio button: YMD - Year/Month/Day
This is YearMonthDay

If you determine that the actual layout of the dates given in the imported file is in the format YMD,

For example:
Date: April 9, 2001
Formatted as 2001/04/09 01/04/09 20010409

Then select the YMD - Year/Month/Day radio button.

Top of page.

DMY - Day/Month/Year

Radio button: DMY - Day/Month/Year
This is DayMonthYear

If you determine that the actual layout of the dates given in the imported file is in the format DMY,

For example:
Date: April 9, 2001
Formatted as 09/04/2001 09/04/01 09042001

Then select the DMY - Day/Month/Year radio button.

Top of page.

YYYYDDD - Year/Day

Radio button: YYYYddd - Year/Day
This is YearDayofYear

If you determine that the actual layout of the dates given in the imported file is in the format YYYYddd,

For example:
Date: April 9, 2001
Formatted as 2001/99 200199

Then select the YYYYddd - Year/Day radio button.

Please note that ddd or DayofYear indicates the actual numeric value of the day in the whole year. In the example, April 9th is actually the 99th day of the whole calendar year of 365 days.

Top of page.

Ddd - Day Of Year

Radio button: ddd - Day of Year
This is DayofYear

If you determine that the actual layout of the dates given in the imported file is in the format ddd,

For example:
Date: April 9, 2001
Formatted as 99

Then select the ddd - Day of Year radio button.

Please note that ddd or DayofYear indicates the actual numeric value of the day in the whole year. In the example, April 9th is actually the 99th day of the whole calendar year of 365 days.

Top of page.

Custom Date Separator

You must inform Collect! that the date format includes a date separator. The default value is /. Sometimes different systems use different formats.

For example:
Date: April 9, 2001
Formatted as 04/09/2001 or 04.09.2001 or 04-09-2001

Enter the date separator in this field as / or . or - as per examples above.

Top of page.

Day Leading Zero

(05 VS. 5)

Check this check box if the date segment in the import file has preappended a 0 if the day is a single figure. Do not trust the display in a spreadsheet as this often removes leading zeroes. To determine the actual layout, it is necessary to view your file in a text editor, such as Notepad.

For example:
Date: April 9, 2001
Formatted as 04/09/2001

Leave this check box blank if the date segment in the import file has NO preappended 0 to the day with a single digit.

For example:
Date: April 9, 2001
Formatted as 4/9/2001

Top of page.

Month Leading Zero

(03 VS. 3)

Check this check box if the date segment in the import file has preappended a 0 if the month is a single figure. Do not trust the display in a spreadsheet as this often removes leading zeroes. To determine the actual layout, it is necessary to view your file in a text editor, such as Notepad.

For example:
Date: April 9, 2001
Formatted as 04/09/2001

Leave this check box blank if the date segment in the import file has NO preappended 0 to the month with a single digit.

For example:
Date: April 9, 2001
Formatted as 4/9/2001

Top of page.

Century

(1995 VS. 95)

Check this check box if the date segment in the import file has the century in a long format. Do not trust the display in a spreadsheet as this often reformats dates as it displays them. To determine the actual layout, it is necessary to view your file in a text editor, such as Notepad.

For example:
Date: April 9, 2001
Formatted as 04/09/2001

Leave this check box blank if the date segment in the import file has the century in a short 2 digit format.

For example:
Date: April 9, 2001
Formatted as 04/09/01

Top of page.

No Separator

Check this check box if there is NO SEPARATOR at all in the date segment in the import file. Do not trust the display in a spreadsheet as this often reformats dates as it displays them. To determine the actual layout, it is necessary to view your file in a text editor, such as Notepad.

For example:
Date: April 9, 2001
Formatted as 04092001 040901

This will inform Collect! not to look for a separator in the date segment.

Top of page.

Help

Press this button for help on the Import Date Options dialog and links to related topics.

Top of page.

Cancel

Select this button to ignore any changes you may have made and then return to the previous form.

Top of page.

OK

Selecting this button will save any data you have entered and return you to the previous form.

Top of page.

See Also

- Import Field Date Format
- Import/Export Topics

Top of page.

Was this page helpful? Do you have any comments on this document? Can we make it better? If so how may we improve this page.

Please click this link to send us your comments: helpinfo@collect.org