Calendar Summary
The Service Date Dimension expands the line-item service date available on selected QuickBooks transactions. It supports analysis of when individual products or services were provided.
Calendar Type Line-item service date | Date Represents Date a line item is provided |
QuickBooks Source Selected transaction line items | Primary Use Service-date analysis |
Included Data Models Customers: Sales, Accounts Receivable Operations: Purchases, Open Purchase Orders, Inventory, Job Cost Details Finance: General Ledger Detail, Profit and Loss Detail, Cash Position | |
QuickBooks Source
Service Date is a line-item date available on selected QuickBooks transactions. Unlike most transaction dates, it can vary between individual lines on the same document.
Source Transactions
- Invoice
- Credit Memo
- Sales Receipt
- Purchase Order
Source Example
Available Fields
The following fields are included in the Service Date Dimension.
| Display Order | Field Name |
|---|---|
| 1 | Service Date |
| 2 | Service Date Calendar Month Number |
| 3 | Service Date Calendar Year Number |
| 4 | Service Date Day Holiday Name |
| 5 | Service Date Day Is Holiday |
| 6 | Service Date Day Is Weekend Day |
| 7 | Service Date Day is Working Day |
| 8 | Service Date Day Number in Month |
| 9 | Service Date Day Number in Quarter |
| 10 | Service Date Day Number in Week |
| 11 | Service Date Day Number in Year |
| 12 | Service Date Day of Week |
| 13 | Service Date Day of Week Abbr |
| 14 | Service Date Formal Date |
| 15 | Service Date Month Abbr |
| 16 | Service Date Month Begin Date |
| 17 | Service Date Month End Date |
| 18 | Service Date Month Name |
| 19 | Service Date Month Number |
| 20 | Service Date Month Number in Quarter |
| 21 | Service Date Month-Year |
| 22 | Service Date Quarter (FQ) |
| 23 | Service Date Quarter (Q) |
| 24 | Service Date Quarter Begin Date |
| 25 | Service Date Quarter End Date |
| 26 | Service Date Quarter Number |
| 27 | Service Date Quarter-Year (FQ) |
| 28 | Service Date Quarter-Year (Q) |
| 29 | Service Date Week Begin Date |
| 30 | Service Date Week End Date |
| 31 | Service Date Year (FY) |
| 32 | Service Date Year (Y) |
| 33 | Service Date Year Begin Date |
| 34 | Service Date Year End Date |
| 35 | Service Date Year Number |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article