Endpoint: DatesByMonth
Overview
The MYOB DatesByMonth endpoint allows you to access a list of date ranges for each month.
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 DatesByMonth endpoint.
- DatesByMonthID
- A text field provides the key to this data.
- FinancialYear
- A intger field that provides the financial year for this month.
- FinancialMonth
- A intger field that provides the financial month period for this month.
- CalendarYear
- A intger field that provides the calendar year for this month.
- CalendarMonth
- A intger field that provides the calendar month for this month.
- FirstDate
- A date time offset field that provides the first date of the month.
- LastDate
- A date time offset field that provides the last date of the month.
- 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