Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Data Type

Discussion

boolean

The possible values are the strings true and false.

date

The date format is yyyy-mm-dd. For example, 2004-12-26.

dateTime

The dateTime format is yyyy-mm-ddThhMMssddThh:MM:ss.fffffff<tzadjustment>

  • Note the letter T between 'dd' and 'hh'. It must be present between the date and time
  • .fffffff - fraction of a second - is optional
  • <tzadjustment> is optional and shows the hours relative to GMT
    • Time is GMT. For our servers that is currently -05:00 hours, but could change if the timezone setting of our servers change. 
    • For example the first two and last two examples represent the same time.
    • 2004-12-27T11:04:29.4370000*-05:00*
    • 2004-12-27T06:04:29.4370000
    • 2004-12-27T11:04:29*-05:00*
    • 2004-12-27T10:04:29

int

A signed integer internally represented by 32 bits

long

A signed integer internally represented by 64 bits

money

A decimal number with 4 places to the right of the decimal point.

float

A floating point number (internally represented by 4 bytes)

double

A double precision floating point number (internally 8 bytes)

ClientUdf

see below

ProjectUdf

see below

EngagementUdf

see below

ResourceUdf

see below

...