Trip Start Date Dimension

Modified on Mon, 27 Jul at 9:46 PM

Calendar Summary

The Trip Start Date Dimension expands the beginning date stored with a QuickBooks Vehicle Mileage entry. It provides the supporting start-date calendar for mileage and job-cost analysis, while Trip End Date remains the primary calendar for completed trips.

Calendar Type

Vehicle mileage date

Date Represents

Trip starting date

QuickBooks Source

Vehicle Mileage entry

Primary Use

Supporting trip-start analysis

Included Data Models

Operations: Job Cost Details, Vehicle Mileage

QuickBooks Source

Trip Start Date comes from the beginning date entered on a QuickBooks Vehicle Mileage record. It supplements the primary Trip End Date calendar when analysis requires the start of the trip.

Source Transactions

Vehicle Mileage entry

Source Example

QuickBooks Vehicle Mileage trip start date source

Available Fields

The following fields are included in the Trip Start Date Dimension.

Display Order	Field Name
1	Trip Start Date
2	Trip Start Date Day Holiday Name
3	Trip Start Date Day Is Holiday
4	Trip Start Date Day Is Weekend Day
5	Trip Start Date Day is Working Day
6	Trip Start Date Day Number in Month
7	Trip Start Date Day Number in Quarter
8	Trip Start Date Day Number in Week
9	Trip Start Date Day Number in Year
10	Trip Start Date Day of Week
11	Trip Start Date Day of Week Abbr
12	Trip Start Date Formal Date
13	Trip Start Date Month Abbr
14	Trip Start Date Month Begin Date
15	Trip Start Date Month End Date
16	Trip Start Date Month Name
17	Trip Start Date Month Number
18	Trip Start Date Month-Year
19	Trip Start Date Quarter
20	Trip Start Date Quarter Begin Date
21	Trip Start Date Quarter End Date
22	Trip Start Date Quarter Number
23	Trip Start Date Quarter-Year
24	Trip Start Date Week Begin Date
25	Trip Start Date Week End Date
26	Trip Start Date Year
27	Trip Start Date Year Begin Date
28	Trip Start Date Year End Date
29	Trip Start Date Year Number