Date

Overview

This entity contains information about date and other date expressions.

Which dates are included?

This entity has the dates which illustrate when particular actions, events, or calculations took place. For each action the timestamp is stored. This timestamp can be described more precisely using its properties.

Usage in itslearning

This entity is not used in the Itslearning application, this is a technical table (standard technical table in Data Warehouse).

Notes

The last available date is the last processing date.
There are also historical dates added to the entity (before the API was introduced for the customer).

Relationships

Time is linked to:

Diagram

Entity Details

Name	Datatype	Nullable	Description
DateId	Edm.Int32	false	Technical id of the date
DateValue	Edm.DateTime		Daily date stored in DateTime format
DateTitle	Edm.String		Daily date stored as text
MonthOfYear	Edm.Int16		Month number
Year	Edm.Int16		Year of the date
QuarterOfYear	Edm.Int16		Quarter number
DayName	Edm.String		Weekday name
DayNameAbbr	Edm.String		Abbreviated weekday name
IsWeekday	Edm.String		Determines whether the date represents a weekday
DayOfWeek	Edm.Int16	false	Number of the day of the week
MonthName	Edm.String		Month name
MonthNameAbbr	Edm.String		Abbreviated month name
WeekOfYear	Edm.Int16		Week number in a year
MonthlyDateKey	Edm.Int32	false	Technical key

Request body

URI

https://reporting.itslearning.com/odata/engine7/Dates?$top=10

Response body - XML

XML response

<?xml version="1.0" encoding="utf-8"?>
<feed xml:base="https://reporting.itslearning.com/odata/engine7" xmlns="http://www.w3.org/2005/Atom" xmlns:d="http://schemas.microsof
t.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:georss="http://www.geo
rss.org/georss" xmlns:gml="http://www.opengis.net/gml">
  <id>http://schemas.datacontract.org/2004/07/</id>
  <title />
  <updated>2016-12-22T09:44:04Z</updated>
  <link rel="self" href="https://reporting.itslearning.com/odata/engine7/Dates" />
  <entry>
    <id>https://reporting.itslearning.com/odata/engine7/Dates(19000101)</id>
    <category term="Itslearning.Reporting.Data.Models.Date" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Dates(19000101)" />
    <link rel="self" href="https://reporting.itslearning.com/odata/engine7/Dates(19000101)" />
    <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseVisits" type="application/atom+xml;type=feed" titl
e="CourseVisits" href="https://reporting.itslearning.com/odata/engine7/Dates(19000101)/CourseVisits" />
    <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserLogins" type="application/atom+xml;type=feed" title=
"UserLogins" href="https://reporting.itslearning.com/odata/engine7/Dates(19000101)/UserLogins" />
    <title />
    <updated>2016-12-22T09:44:04Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:DateId m:type="Edm.Int32">19000101</d:DateId>
        <d:DateValue m:type="Edm.DateTime">1900-01-01T00:00:00</d:DateValue>
        <d:DateTitle>1900-01-01</d:DateTitle>
        <d:MonthOfYear m:type="Edm.Int16">1</d:MonthOfYear>
        <d:Year m:type="Edm.Int16">1900</d:Year>
        <d:QuarterOfYear m:type="Edm.Int16">1</d:QuarterOfYear>
        <d:DayName>Monday</d:DayName>
        <d:DayNameAbbr>Mon</d:DayNameAbbr>
        <d:IsWeekday>Yes</d:IsWeekday>
        <d:DayOfWeek m:type="Edm.Int16">2</d:DayOfWeek>
        <d:MonthName>January</d:MonthName>
        <d:MonthNameAbbr>Jan</d:MonthNameAbbr>
        <d:WeekOfYear m:type="Edm.Int16">1</d:WeekOfYear>
        <d:MonthlyDateKey m:type="Edm.Int32">19000101</d:MonthlyDateKey>
      </m:properties>
    </content>
  </entry>
  <entry>
    <id>https://reporting.itslearning.com/odata/engine7/Dates(19900101)</id>
    <category term="Itslearning.Reporting.Data.Models.Date" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Dates(19900101)" />
    <link rel="self" href="https://reporting.itslearning.com/odata/engine7/Dates(19900101)" />
    <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseVisits" type="application/atom+xml;type=feed" titl
e="CourseVisits" href="https://reporting.itslearning.com/odata/engine7/Dates(19900101)/CourseVisits" />
    <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserLogins" type="application/atom+xml;type=feed" title=
"UserLogins" href="https://reporting.itslearning.com/odata/engine7/Dates(19900101)/UserLogins" />
    <title />
    <updated>2016-12-22T09:44:04Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:DateId m:type="Edm.Int32">19900101</d:DateId>
        <d:DateValue m:type="Edm.DateTime">1990-01-01T00:00:00</d:DateValue>
        <d:DateTitle>1990-01-01</d:DateTitle>
        <d:MonthOfYear m:type="Edm.Int16">1</d:MonthOfYear>
        <d:Year m:type="Edm.Int16">1990</d:Year>
        <d:QuarterOfYear m:type="Edm.Int16">1</d:QuarterOfYear>
        <d:DayName>Monday</d:DayName>
        <d:DayNameAbbr>Mon</d:DayNameAbbr>
        <d:IsWeekday>Yes</d:IsWeekday>
        <d:DayOfWeek m:type="Edm.Int16">2</d:DayOfWeek>
        <d:MonthName>January</d:MonthName>
        <d:MonthNameAbbr>Jan</d:MonthNameAbbr>
        <d:WeekOfYear m:type="Edm.Int16">1</d:WeekOfYear>
        <d:MonthlyDateKey m:type="Edm.Int32">19900101</d:MonthlyDateKey>
      </m:properties>
    </content>
  </entry>
  <entry>
    <id>https://reporting.itslearning.com/odata/engine7/Dates(19900102)</id>
    <category term="Itslearning.Reporting.Data.Models.Date" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Dates(19900102)" />
    <link rel="self" href="https://reporting.itslearning.com/odata/engine7/Dates(19900102)" />
    <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseVisits" type="application/atom+xml;type=feed" titl
e="CourseVisits" href="https://reporting.itslearning.com/odata/engine7/Dates(19900102)/CourseVisits" />
    <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserLogins" type="application/atom+xml;type=feed" title=
"UserLogins" href="https://reporting.itslearning.com/odata/engine7/Dates(19900102)/UserLogins" />
    <title />
    <updated>2016-12-22T09:44:04Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:DateId m:type="Edm.Int32">19900102</d:DateId>
        <d:DateValue m:type="Edm.DateTime">1990-01-02T00:00:00</d:DateValue>
        <d:DateTitle>1990-01-02</d:DateTitle>
        <d:MonthOfYear m:type="Edm.Int16">1</d:MonthOfYear>
        <d:Year m:type="Edm.Int16">1990</d:Year>
        <d:QuarterOfYear m:type="Edm.Int16">1</d:QuarterOfYear>
        <d:DayName>Tuesday</d:DayName>
        <d:DayNameAbbr>Tue</d:DayNameAbbr>
        <d:IsWeekday>Yes</d:IsWeekday>
        <d:DayOfWeek m:type="Edm.Int16">3</d:DayOfWeek>
        <d:MonthName>January</d:MonthName>
        <d:MonthNameAbbr>Jan</d:MonthNameAbbr>
        <d:WeekOfYear m:type="Edm.Int16">1</d:WeekOfYear>
        <d:MonthlyDateKey m:type="Edm.Int32">19900101</d:MonthlyDateKey>
      </m:properties>
    </content>
  </entry>
  <entry>
    <id>https://reporting.itslearning.com/odata/engine7/Dates(19900103)</id>
    <category term="Itslearning.Reporting.Data.Models.Date" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Dates(19900103)" />
    <link rel="self" href="https://reporting.itslearning.com/odata/engine7/Dates(19900103)" />
    <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseVisits" type="application/atom+xml;type=feed" titl
e="CourseVisits" href="https://reporting.itslearning.com/odata/engine7/Dates(19900103)/CourseVisits" />
    <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserLogins" type="application/atom+xml;type=feed" title=
"UserLogins" href="https://reporting.itslearning.com/odata/engine7/Dates(19900103)/UserLogins" />
    <title />
    <updated>2016-12-22T09:44:04Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:DateId m:type="Edm.Int32">19900103</d:DateId>
        <d:DateValue m:type="Edm.DateTime">1990-01-03T00:00:00</d:DateValue>
        <d:DateTitle>1990-01-03</d:DateTitle>
        <d:MonthOfYear m:type="Edm.Int16">1</d:MonthOfYear>
        <d:Year m:type="Edm.Int16">1990</d:Year>
        <d:QuarterOfYear m:type="Edm.Int16">1</d:QuarterOfYear>
        <d:DayName>Wednesday</d:DayName>
        <d:DayNameAbbr>Wed</d:DayNameAbbr>
        <d:IsWeekday>Yes</d:IsWeekday>
        <d:DayOfWeek m:type="Edm.Int16">4</d:DayOfWeek>
        <d:MonthName>January</d:MonthName>
        <d:MonthNameAbbr>Jan</d:MonthNameAbbr>
        <d:WeekOfYear m:type="Edm.Int16">1</d:WeekOfYear>
        <d:MonthlyDateKey m:type="Edm.Int32">19900101</d:MonthlyDateKey>
      </m:properties>
    </content>
  </entry>
  <entry>
    <id>https://reporting.itslearning.com/odata/engine7/Dates(19900104)</id>
    <category term="Itslearning.Reporting.Data.Models.Date" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Dates(19900104)" />
    <link rel="self" href="https://reporting.itslearning.com/odata/engine7/Dates(19900104)" />
    <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseVisits" type="application/atom+xml;type=feed" titl
e="CourseVisits" href="https://reporting.itslearning.com/odata/engine7/Dates(19900104)/CourseVisits" />
    <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserLogins" type="application/atom+xml;type=feed" title=
"UserLogins" href="https://reporting.itslearning.com/odata/engine7/Dates(19900104)/UserLogins" />
    <title />
    <updated>2016-12-22T09:44:04Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:DateId m:type="Edm.Int32">19900104</d:DateId>
        <d:DateValue m:type="Edm.DateTime">1990-01-04T00:00:00</d:DateValue>
        <d:DateTitle>1990-01-04</d:DateTitle>
        <d:MonthOfYear m:type="Edm.Int16">1</d:MonthOfYear>
        <d:Year m:type="Edm.Int16">1990</d:Year>
        <d:QuarterOfYear m:type="Edm.Int16">1</d:QuarterOfYear>
        <d:DayName>Thursday</d:DayName>
        <d:DayNameAbbr>Thu</d:DayNameAbbr>
        <d:IsWeekday>Yes</d:IsWeekday>
        <d:DayOfWeek m:type="Edm.Int16">5</d:DayOfWeek>
        <d:MonthName>January</d:MonthName>
        <d:MonthNameAbbr>Jan</d:MonthNameAbbr>
        <d:WeekOfYear m:type="Edm.Int16">1</d:WeekOfYear>
        <d:MonthlyDateKey m:type="Edm.Int32">19900101</d:MonthlyDateKey>
      </m:properties>
    </content>
  </entry>
  <entry>
    <id>https://reporting.itslearning.com/odata/engine7/Dates(19900105)</id>
    <category term="Itslearning.Reporting.Data.Models.Date" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Dates(19900105)" />
    <link rel="self" href="https://reporting.itslearning.com/odata/engine7/Dates(19900105)" />
    <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseVisits" type="application/atom+xml;type=feed" titl
e="CourseVisits" href="https://reporting.itslearning.com/odata/engine7/Dates(19900105)/CourseVisits" />
    <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserLogins" type="application/atom+xml;type=feed" title=
"UserLogins" href="https://reporting.itslearning.com/odata/engine7/Dates(19900105)/UserLogins" />
    <title />
    <updated>2016-12-22T09:44:04Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:DateId m:type="Edm.Int32">19900105</d:DateId>
        <d:DateValue m:type="Edm.DateTime">1990-01-05T00:00:00</d:DateValue>
        <d:DateTitle>1990-01-05</d:DateTitle>
        <d:MonthOfYear m:type="Edm.Int16">1</d:MonthOfYear>
        <d:Year m:type="Edm.Int16">1990</d:Year>
        <d:QuarterOfYear m:type="Edm.Int16">1</d:QuarterOfYear>
        <d:DayName>Friday</d:DayName>
        <d:DayNameAbbr>Fri</d:DayNameAbbr>
        <d:IsWeekday>Yes</d:IsWeekday>
        <d:DayOfWeek m:type="Edm.Int16">6</d:DayOfWeek>
        <d:MonthName>January</d:MonthName>
        <d:MonthNameAbbr>Jan</d:MonthNameAbbr>
        <d:WeekOfYear m:type="Edm.Int16">1</d:WeekOfYear>
        <d:MonthlyDateKey m:type="Edm.Int32">19900101</d:MonthlyDateKey>
      </m:properties>
    </content>
  </entry>
  <entry>
    <id>https://reporting.itslearning.com/odata/engine7/Dates(19900106)</id>
    <category term="Itslearning.Reporting.Data.Models.Date" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Dates(19900106)" />
    <link rel="self" href="https://reporting.itslearning.com/odata/engine7/Dates(19900106)" />
    <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseVisits" type="application/atom+xml;type=feed" titl
e="CourseVisits" href="https://reporting.itslearning.com/odata/engine7/Dates(19900106)/CourseVisits" />
    <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserLogins" type="application/atom+xml;type=feed" title=
"UserLogins" href="https://reporting.itslearning.com/odata/engine7/Dates(19900106)/UserLogins" />
    <title />
    <updated>2016-12-22T09:44:04Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:DateId m:type="Edm.Int32">19900106</d:DateId>
        <d:DateValue m:type="Edm.DateTime">1990-01-06T00:00:00</d:DateValue>
        <d:DateTitle>1990-01-06</d:DateTitle>
        <d:MonthOfYear m:type="Edm.Int16">1</d:MonthOfYear>
        <d:Year m:type="Edm.Int16">1990</d:Year>
        <d:QuarterOfYear m:type="Edm.Int16">1</d:QuarterOfYear>
        <d:DayName>Saturday</d:DayName>
        <d:DayNameAbbr>Sat</d:DayNameAbbr>
        <d:IsWeekday>No</d:IsWeekday>
        <d:DayOfWeek m:type="Edm.Int16">7</d:DayOfWeek>
        <d:MonthName>January</d:MonthName>
        <d:MonthNameAbbr>Jan</d:MonthNameAbbr>
        <d:WeekOfYear m:type="Edm.Int16">1</d:WeekOfYear>
        <d:MonthlyDateKey m:type="Edm.Int32">19900101</d:MonthlyDateKey>
      </m:properties>
    </content>
  </entry>
  <entry>
    <id>https://reporting.itslearning.com/odata/engine7/Dates(19900107)</id>
    <category term="Itslearning.Reporting.Data.Models.Date" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Dates(19900107)" />
    <link rel="self" href="https://reporting.itslearning.com/odata/engine7/Dates(19900107)" />
    <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseVisits" type="application/atom+xml;type=feed" titl
e="CourseVisits" href="https://reporting.itslearning.com/odata/engine7/Dates(19900107)/CourseVisits" />
    <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserLogins" type="application/atom+xml;type=feed" title=
"UserLogins" href="https://reporting.itslearning.com/odata/engine7/Dates(19900107)/UserLogins" />
    <title />
    <updated>2016-12-22T09:44:04Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:DateId m:type="Edm.Int32">19900107</d:DateId>
        <d:DateValue m:type="Edm.DateTime">1990-01-07T00:00:00</d:DateValue>
        <d:DateTitle>1990-01-07</d:DateTitle>
        <d:MonthOfYear m:type="Edm.Int16">1</d:MonthOfYear>
        <d:Year m:type="Edm.Int16">1990</d:Year>
        <d:QuarterOfYear m:type="Edm.Int16">1</d:QuarterOfYear>
        <d:DayName>Sunday</d:DayName>
        <d:DayNameAbbr>Sun</d:DayNameAbbr>
        <d:IsWeekday>No</d:IsWeekday>
        <d:DayOfWeek m:type="Edm.Int16">1</d:DayOfWeek>
        <d:MonthName>January</d:MonthName>
        <d:MonthNameAbbr>Jan</d:MonthNameAbbr>
        <d:WeekOfYear m:type="Edm.Int16">2</d:WeekOfYear>
        <d:MonthlyDateKey m:type="Edm.Int32">19900101</d:MonthlyDateKey>
      </m:properties>
    </content>
  </entry>
  <entry>
    <id>https://reporting.itslearning.com/odata/engine7/Dates(19900108)</id>
    <category term="Itslearning.Reporting.Data.Models.Date" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Dates(19900108)" />
    <link rel="self" href="https://reporting.itslearning.com/odata/engine7/Dates(19900108)" />
    <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseVisits" type="application/atom+xml;type=feed" titl
e="CourseVisits" href="https://reporting.itslearning.com/odata/engine7/Dates(19900108)/CourseVisits" />
    <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserLogins" type="application/atom+xml;type=feed" title=
"UserLogins" href="https://reporting.itslearning.com/odata/engine7/Dates(19900108)/UserLogins" />
    <title />
    <updated>2016-12-22T09:44:04Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:DateId m:type="Edm.Int32">19900108</d:DateId>
        <d:DateValue m:type="Edm.DateTime">1990-01-08T00:00:00</d:DateValue>
        <d:DateTitle>1990-01-08</d:DateTitle>
        <d:MonthOfYear m:type="Edm.Int16">1</d:MonthOfYear>
        <d:Year m:type="Edm.Int16">1990</d:Year>
        <d:QuarterOfYear m:type="Edm.Int16">1</d:QuarterOfYear>
        <d:DayName>Monday</d:DayName>
        <d:DayNameAbbr>Mon</d:DayNameAbbr>
        <d:IsWeekday>Yes</d:IsWeekday>
        <d:DayOfWeek m:type="Edm.Int16">2</d:DayOfWeek>
        <d:MonthName>January</d:MonthName>
        <d:MonthNameAbbr>Jan</d:MonthNameAbbr>
        <d:WeekOfYear m:type="Edm.Int16">2</d:WeekOfYear>
        <d:MonthlyDateKey m:type="Edm.Int32">19900101</d:MonthlyDateKey>
      </m:properties>
    </content>
  </entry>
  <entry>
    <id>https://reporting.itslearning.com/odata/engine7/Dates(19900109)</id>
    <category term="Itslearning.Reporting.Data.Models.Date" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Dates(19900109)" />
    <link rel="self" href="https://reporting.itslearning.com/odata/engine7/Dates(19900109)" />
    <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseVisits" type="application/atom+xml;type=feed" titl
e="CourseVisits" href="https://reporting.itslearning.com/odata/engine7/Dates(19900109)/CourseVisits" />
    <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserLogins" type="application/atom+xml;type=feed" title=
"UserLogins" href="https://reporting.itslearning.com/odata/engine7/Dates(19900109)/UserLogins" />
    <title />
    <updated>2016-12-22T09:44:04Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:DateId m:type="Edm.Int32">19900109</d:DateId>
        <d:DateValue m:type="Edm.DateTime">1990-01-09T00:00:00</d:DateValue>
        <d:DateTitle>1990-01-09</d:DateTitle>
        <d:MonthOfYear m:type="Edm.Int16">1</d:MonthOfYear>
        <d:Year m:type="Edm.Int16">1990</d:Year>
        <d:QuarterOfYear m:type="Edm.Int16">1</d:QuarterOfYear>
        <d:DayName>Tuesday</d:DayName>
        <d:DayNameAbbr>Tue</d:DayNameAbbr>
        <d:IsWeekday>Yes</d:IsWeekday>
        <d:DayOfWeek m:type="Edm.Int16">3</d:DayOfWeek>
        <d:MonthName>January</d:MonthName>
        <d:MonthNameAbbr>Jan</d:MonthNameAbbr>
        <d:WeekOfYear m:type="Edm.Int16">2</d:WeekOfYear>
        <d:MonthlyDateKey m:type="Edm.Int32">19900101</d:MonthlyDateKey>
      </m:properties>
    </content>
  </entry>
</feed>

Response body - JSON (default output format)

JSON response

{
  "odata.metadata":"https://reporting.itslearning.com/odata/engine7/$metadata#Dates","value":[
    {
      "DateId":19000101,"DateValue":"1900-01-01T00:00:00","DateTitle":"1900-01-01","MonthOfYear":1,"Year":1900,"QuarterOfYear":1,"DayName":"Monday","DayNameAbbr":"Mon","IsWeekday":"Yes","DayOfWeek":2,"MonthName":"January","Mont
hNameAbbr":"Jan","WeekOfYear":1,"MonthlyDateKey":19000101
    },{
      "DateId":19900101,"DateValue":"1990-01-01T00:00:00","DateTitle":"1990-01-01","MonthOfYear":1,"Year":1990,"QuarterOfYear":1,"DayName":"Monday","DayNameAbbr":"Mon","IsWeekday":"Yes","DayOfWeek":2,"MonthName":"January","Mont
hNameAbbr":"Jan","WeekOfYear":1,"MonthlyDateKey":19900101
    },{
      "DateId":19900102,"DateValue":"1990-01-02T00:00:00","DateTitle":"1990-01-02","MonthOfYear":1,"Year":1990,"QuarterOfYear":1,"DayName":"Tuesday","DayNameAbbr":"Tue","IsWeekday":"Yes","DayOfWeek":3,"MonthName":"January","Mon
thNameAbbr":"Jan","WeekOfYear":1,"MonthlyDateKey":19900101
    },{
      "DateId":19900103,"DateValue":"1990-01-03T00:00:00","DateTitle":"1990-01-03","MonthOfYear":1,"Year":1990,"QuarterOfYear":1,"DayName":"Wednesday","DayNameAbbr":"Wed","IsWeekday":"Yes","DayOfWeek":4,"MonthName":"January","M
onthNameAbbr":"Jan","WeekOfYear":1,"MonthlyDateKey":19900101
    },{
      "DateId":19900104,"DateValue":"1990-01-04T00:00:00","DateTitle":"1990-01-04","MonthOfYear":1,"Year":1990,"QuarterOfYear":1,"DayName":"Thursday","DayNameAbbr":"Thu","IsWeekday":"Yes","DayOfWeek":5,"MonthName":"January","Mo
nthNameAbbr":"Jan","WeekOfYear":1,"MonthlyDateKey":19900101
    },{
      "DateId":19900105,"DateValue":"1990-01-05T00:00:00","DateTitle":"1990-01-05","MonthOfYear":1,"Year":1990,"QuarterOfYear":1,"DayName":"Friday","DayNameAbbr":"Fri","IsWeekday":"Yes","DayOfWeek":6,"MonthName":"January","Mont
hNameAbbr":"Jan","WeekOfYear":1,"MonthlyDateKey":19900101
    },{
      "DateId":19900106,"DateValue":"1990-01-06T00:00:00","DateTitle":"1990-01-06","MonthOfYear":1,"Year":1990,"QuarterOfYear":1,"DayName":"Saturday","DayNameAbbr":"Sat","IsWeekday":"No","DayOfWeek":7,"MonthName":"January","Mon
thNameAbbr":"Jan","WeekOfYear":1,"MonthlyDateKey":19900101
    },{
      "DateId":19900107,"DateValue":"1990-01-07T00:00:00","DateTitle":"1990-01-07","MonthOfYear":1,"Year":1990,"QuarterOfYear":1,"DayName":"Sunday","DayNameAbbr":"Sun","IsWeekday":"No","DayOfWeek":1,"MonthName":"January","Month
NameAbbr":"Jan","WeekOfYear":2,"MonthlyDateKey":19900101
    },{
      "DateId":19900108,"DateValue":"1990-01-08T00:00:00","DateTitle":"1990-01-08","MonthOfYear":1,"Year":1990,"QuarterOfYear":1,"DayName":"Monday","DayNameAbbr":"Mon","IsWeekday":"Yes","DayOfWeek":2,"MonthName":"January","Mont
hNameAbbr":"Jan","WeekOfYear":2,"MonthlyDateKey":19900101
    },{
      "DateId":19900109,"DateValue":"1990-01-09T00:00:00","DateTitle":"1990-01-09","MonthOfYear":1,"Year":1990,"QuarterOfYear":1,"DayName":"Tuesday","DayNameAbbr":"Tue","IsWeekday":"Yes","DayOfWeek":3,"MonthName":"January","Mon
thNameAbbr":"Jan","WeekOfYear":2,"MonthlyDateKey":19900101
    }
  ]
}