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).

Diagram

images/download/attachments/284208101/Date.PNG

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
}
]
}