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

Employees

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