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 hasn't used in itslearning, this is a technical table (standard technical table in Data Warehouse).

Notes

  • The last available date is last processing date.

  • There are also historical dates added to the entity (before the API was introduced for the customer).

Diagram

images/download/attachments/41660890/Date.PNG

Entity Details

Name

Datatype

Nullable

Description

DateId

Edm.Int32

false

technical ID (primary key)

DateValue

Edm.DateTime

daily date stored indatetimeformat

DateTitle

Edm.String

daily date stored as text

MonthOfYear

Edm.Int16

month number

Year

Edm.Int16

year from date

QuarterOfYear

Edm.Int16

quarter number

DayName

Edm.String

weekday name

DayNameAbbr

Edm.String

abbreviated weekday name

IsWeekday

Edm.String

yes / nofor 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

SQL code

DECLARE @pProcessTo DATETIME = getdate (),@pProcessFrom DATETIME = '1900-01-01' ;
WITH cte AS ( SELECT CAST ( CAST ( GETUTCDATE () AS DATE ) AS DATETIME ) AS dt UNION ALL SELECT dt - 1 FROM cte WHERE dt >= CONVERT ( DATETIME , '1990-01-01' , 120 )) SELECT CONVERT ( INT , CONVERT ( NVARCHAR ( 8 ),DT, 112 )) AS [DateKey],DT AS [Date], CONVERT ( NVARCHAR ( 10 ),DT, 120 ) AS [DateTitle], N'Year ' + CONVERT ( NVARCHAR , YEAR ( DT )) AS [YearTitle], N'Month ' + CONVERT ( NVARCHAR , MONTH ( DT )) AS [MonthTitle], CONVERT ( NVARCHAR ( 10 ),DT, 120 ) AS [YearMonthDay], CONVERT ( NVARCHAR ( 10 ),DT, 110 ) AS [MonthDayYear], CONVERT ( NVARCHAR ( 10 ),DT, 105 ) AS [DayMonthYear], N'Day' AS [DateType], DAY ( DT ) AS [DayOfMonth], MONTH ( DT ) AS [MonthOfYear], YEAR ( DT ) AS [Year], DATEPART ( QUARTER,DT ) AS [QuarterOfYear], DATENAME ( DW,DT ) AS [DayName],LEFT( DATENAME ( DW,DT ), 3 ) AS [DayNameAbbr], CASE WHEN DATEPART ( DW,DT ) IN ( 7 , 1 ) THEN N'No' ELSE N'Yes' END AS [IsWeekday], DATEPART ( DW,DT ) AS [DayOfWeek], DATENAME ( MONTH ,DT ) AS [MonthName],LEFT( DATENAME ( MONTH ,DT ), 3 ) AS [MonthNameAbbr], DATEPART ( DAYOFYEAR,DT ) AS [DayOfYear], DATEPART ( WEEK,DT ) AS [WeekOfYear], NULL AS [DayOfMonthCategory], CASE WHEN YEAR ( DATEADD ( DAY , 1 - DATEPART ( WEEKDAY ,DT ),DT )) <> YEAR ( DT ) THEN DATEADD ( yy, DATEDIFF ( yy, 0 ,DT ), 0 ) ELSE DATEADD ( DAY , 1 - DATEPART ( WEEKDAY ,DT ),DT ) END AS WeekStartDate, DATEADD ( mm, DATEDIFF ( mm, 0 ,DT ), 0 ) AS MonthStartDate, DATEADD ( qq, DATEDIFF ( qq, 0 ,DT ), 0 ) AS QuarterStartDate, DATEADD ( yy, DATEDIFF ( yy, 0 ,DT ), 0 ) AS YearStartDate, CONVERT ( INT , CONVERT ( VARCHAR ( 8 ), DATEADD ( mm, DATEDIFF ( mm, 0 ,DT ), 0 ), 112 )) AS MonthlyDateKey,( CASE WHEN DT = CONVERT ( DATE ,@pProcessTo ) THEN 1 ELSE 0 END ) AS IsDateProcessed FROM cte WHERE dt > @pProcessFrom AND dt <= @pProcessTo ORDER BY CONVERT ( INT , CONVERT ( NVARCHAR ( 8 ),DT, 112 )) ASC /* DateKey value */ OPTION ( MAXRECURSION 0 );

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