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

Data Type

Requires Value?

Max Length

Related Table

TaskCode

String

Yes

32

Tasks

SubTaskCode

String

Yes

32

Sub-Tasks

AccountCode

String

Yes

32

Accounts

FinancialMonthCode

FinancialMonth

Yes

6

Financial Months

EmployeeCode

String

No

32

Employees

LaborClassCode

String

No

32

Labor Classes

LaborSubclassCode

String

No

32

Labor Subclasses

VendorCode

String

No

32

Vendors

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