Specifying the date attribute for forms

You can specify a date field in a form that you import using Microsoft Excel. The format for the date depends on the value for the DefaultDateFormat key defined in the timelocal_locale.xml file. This file is located in the following directory:

TC-root-directory\lang\textserver\en_US

If, for example, the following format for the date is specified in the timelocal_locale.xml file:

%d-%b-%Y %H:%M

You must enter the date and time as 15-Aug-2013 18:30 in the Excel input value. The date format is as follows:

%d

Day of the month (0-31)

%b

Abbreviated month name

%Y

Year with century (1970-2069)

%H

Hour (24-hour clock 00-23)

%M

Minute (00-59)

The following spreadsheet shows how to add a date attribute value to the form.

Header1	Item	Attribute	Attribute
Header2	Item	Item Master	Item Master
Header3	Item	fnd0Date	user_data_3
Title	Name	Date Attribute	User Data
	Test	19-Aug-2013 18:30	check

This example imports an item called Test and the two attributes on the Item Master form, fnd0Date and user_data_3, are updated with the values 19-Aug-2013 18:30 and check, respectively.

Note

The fnd0Date attribute is added on the Item Master form for illustration purposes only. This attribute is not available by default in Teamcenter.