Date
The Date Data Type will contain data that represents a date value without regard for time.
Date values recognize only the U.S. Localization rules for formatting. In other words, dates should be represented in "month" / "day" / "year" format.
Acceptable Date Ranges
- Minimum Date
- 1/1/1900
- Maximum Date
- 12/31/9999
Acceptable Data Formats
- m/d/yy
- m/d/yyyy
- mm/d/yyyy
- mm/dd/yyyy
Invalid Formats
The following are examples are invalid data formats for the Date Data Type
- Dates that are spelled out
- July 31, 2016
- Dates using foreign Localization Rules
- 31/7/2016
- Dates with time values
- 7/31/2016 2:50:00 PM
Sample Data Specification
Field Name |
Data Type |
Requires Value? |
Max Length |
Related Table |
EmployeeCode |
String |
Yes |
32 |
|
LaborClassCode |
String |
Yes |
32 |
|
LaborSubclassCode |
String |
Yes |
32 |
|
LaborRate |
Numeric |
Yes |
Min: 0 Max: 9999 |
|
LaborRate2 |
Numeric |
Yes |
Min: 0 Max: 9999 |
|
LaborRate3 |
Numeric |
Yes |
Min: 0 Max: 9999 |
|
LaborRate4 |
Numeric |
Yes |
Min: 0 Max: 9999 |
|
LaborRate5 |
Numeric |
Yes |
Min: 0 Max: 9999 |
|
EffectiveDate |
Date |
Yes |
- |
|
Page ID:6132-4029-3876