DateTime
The DateTime Data Type will contain data that represents a date value that also includes the time.
Date values recognize only the U.S. Localization rules for formatting. In other words, dates should be represented in "month" / "day" / "year" format and time should be represented in "Hours" : "Minutes" : "Seconds" "AM/PM".
Acceptable Date Ranges
- Minimum Date
- 1/1/1900 12:00:00 AM
- Maximum Date
- 12/31/9999 11:59:59 PM
Acceptable Data Formats
- m/d/yy h:mm:ss AM/PM
- m/d/yyyy h:mm:ss AM/PM
- mm/d/yyyy h:mm:ss AM/PM
- mm/dd/yyyy h:mm:ss AM/PM
Invalid Formats
The following are examples are invalid data formats for the DateTime Data Type
- Dates that are spelled out
- July 31, 2016 2:50:00 PM
- Dates using foreign Localization Rules
- 31/7/2016 2:50:00 PM
- Dates with time values
- 7/31/2016 2:50:00 PM
Sample Data Specification
|
Field Name |
Requires Value? |
Max Length |
Related Table |
|
|
TaskCode |
String |
Yes |
32 |
|
|
SubTaskCode |
String |
Yes |
32 |
|
|
AccountCode |
String |
Yes |
32 |
|
|
FinancialMonthCode |
FinancialMonth |
Yes |
6 |
|
|
EmployeeCode |
String |
No |
32 |
|
|
LaborClassCode |
String |
No |
32 |
|
|
LaborSubclassCode |
String |
No |
32 |
|
|
VendorCode |
String |
No |
32 |
|
|
Dollars |
Numeric |
Yes |
- |
|
|
Hours |
Numeric |
Yes |
- |
|
|
PONumber |
String |
No |
32 |
|
|
TransactionDate |
DateTime |
No |
- |
|
|
TransactionComment |
String |
No |
256 |
|
|
Custom1 |
String |
No |
64 |
|
|
Custom2 |
String |
No |
64 |
|
|
Custom3 |
String |
No |
64 |
|
|
Custom4 |
String |
No |
64 |
|
|
Custom5 |
String |
No |
64 |
|
|
Custom6 |
String |
No |
64 |
|
|
Custom7 |
String |
No |
64 |
|
|
Custom8 |
String |
No |
64 |
|
|
Custom9 |
String |
No |
64 |
|
|
Custom10 |
String |
No |
64 |
|
|
SourceTransactionID |
String |
No |
64 |
|
|
SourceParentTransactionID |
String |
No |
64 |
|
Page ID:4161-3730-2689