Endpoint: Dates: Difference between revisions

From OdataLink
Jump to navigation Jump to search
Created page with "== Overview == The MYOB '''Currencies''' endpoint allows you to access the list of foreign currencies used in MYOB. This endpoint is not part of the [https://d..."
 
Ash (talk | contribs)
mNo edit summary
 
(9 intermediate revisions by one other user not shown)
Line 1: Line 1:
== Overview ==
== Overview ==


The MYOB '''Currencies''' [[Endpoints|endpoint]] allows you to access the list of foreign currencies used in MYOB.
The OdataLink '''Dates''' [[Endpoints|endpoint]] allows you to access a list of dates.


This endpoint is not part of the [https://developer.myob.com/api/accountright/v2 MYOB API] but specific to OdataLink to ease development.
This endpoint is not part of the [https://developer.xero.com/documentation/api/accounting/overview Xero API] or [https://developer.myob.com/api/accountright/v2 MYOB API] but specific to OdataLink to ease development.
 
The dates provided are based on the [[Default Date Range|default date range configured for your model]] or based on filters applied to some columns.




== Fields ==
== Fields ==


The following fields are available for the Currencies endpoint.
The following fields are available for the Dates endpoint.


;Date
;Date
Line 14: Line 16:


;DatesByMonthID
;DatesByMonthID
:A [[Field Type: Text|text field]] used as key to some other tables.
:A [[Field Type: Text|text field]] used to link to the [[Endpoint: DatesByMonth|DatesByMonth]] endpoint.


;FinancialYear
;FinancialYear
Line 60: Line 62:
;MM
;MM
:A [[Field Type: Text|text field]] that provides the month as 2 digits.
:A [[Field Type: Text|text field]] that provides the month as 2 digits.
:e.g. '07'
:e.g. '08'


;MMM
;MMM
Line 72: Line 74:
;MM-MMM
;MM-MMM
:A [[Field Type: Text|text field]] that provides the month as 2 digits and 3 letters.
:A [[Field Type: Text|text field]] that provides the month as 2 digits and 3 letters.
:e.g. '07-Aug'
:e.g. '08-Aug'


;MM-MMMM
;MM-MMMM
:A [[Field Type: Text|text field]] that provides the month as 2 digits and 4 letters.
:A [[Field Type: Text|text field]] that provides the month as 2 digits and 4 letters.
:e.g. '07-August'
:e.g. '08-August'


;MM-YY
;MM-YY
:A [[Field Type: Text|text field]] that provides the month as 2 digits for the month and 2 digits for the calendar year.
:A [[Field Type: Text|text field]] that provides the month as 2 digits for the month and 2 digits for the calendar year.
:e.g. '07-21'
:e.g. '08-21'


;MM-YYYY
;MM-YYYY
:A [[Field Type: Text|text field]] that provides the month as 2 digits for the month and 4 digits for the calendar year.
:A [[Field Type: Text|text field]] that provides the month as 2 digits for the month and 4 digits for the calendar year.
:e.g. '07-2021'
:e.g. '08-2021'


;MMM-YY
;MMM-YY
Line 104: Line 106:
:[[Endpoint: DatesByMonth|DatesByMonth]]
:[[Endpoint: DatesByMonth|DatesByMonth]]
:[[Endpoint: DatesByYear|DatesByYear]]
:[[Endpoint: DatesByYear|DatesByYear]]
== Related Topics ==
:[[Endpoints]]
:[[MYOB Endpoints]]
:[[Xero Accounting Endpoints]]

Latest revision as of 00:19, 23 March 2026

Overview

The OdataLink Dates endpoint allows you to access a list of dates.

This endpoint is not part of the Xero API or MYOB API but specific to OdataLink to ease development.

The dates provided are based on the default date range configured for your model or based on filters applied to some columns.


Fields

The following fields are available for the Dates endpoint.

Date
A date field that provides the date.
DatesByMonthID
A text field used to link to the DatesByMonth endpoint.
FinancialYear
A intger field that provides the financial year for this date.
FinancialMonth
A intger field that provides the financial month period for this date.
CalendarYear
A intger field that provides the calendar year for this date.
CalendarMonth
A intger field that provides the calendar month for this date.
DisplayStrings
A record field that provides many preformatted display strings.
See DisplayStrings Fields for more information.


DisplayStrings Fields

The DisplayStrings field contains the following sub-fields.


PP
A text field that provides the period index as 2 digits.
e.g. '02'
PP-MMM
A text field that provides the period index as 2 digits for the period index and 3 letters for the month.
e.g. '02-Aug'
PP-MMMM
A text field that provides the period index as 2 digits for the period index and all letters for the month.
e.g. '02-August'
PP-YY
A text field that provides the period index as 2 digits for the period index and 2 digits for the financial year.
e.g. '02-21'
PP-YYYY
A text field that provides the period index as 2 digits for the period index and 4 digits for the financial year.
e.g. '02-2021'
MM
A text field that provides the month as 2 digits.
e.g. '08'
MMM
A text field that provides the month as 3 letters.
e.g. 'Aug'
MMMM
A text field that provides the month as 4 letters.
e.g. 'August'
MM-MMM
A text field that provides the month as 2 digits and 3 letters.
e.g. '08-Aug'
MM-MMMM
A text field that provides the month as 2 digits and 4 letters.
e.g. '08-August'
MM-YY
A text field that provides the month as 2 digits for the month and 2 digits for the calendar year.
e.g. '08-21'
MM-YYYY
A text field that provides the month as 2 digits for the month and 4 digits for the calendar year.
e.g. '08-2021'
MMM-YY
A text field that provides the month as 3 letters for the month and 2 digits for the calendar year.
e.g. 'Aug-21'
MMMM-YYYY
A text field that provides the month as 4 letters for the month and 4 digits for the calendar year.
e.g. 'August-2021'


MYOB API

This endpoint is not part of the MYOB API but specific to OdataLink to ease development.


Related Endpoints

DatesByMonth
DatesByYear


Related Topics

Endpoints
MYOB Endpoints
Xero Accounting Endpoints