Recent Searches

No recent searches

    Popular Articles

      Articles
      View all
        Topics
        View all
          Tickets
          View all
            no results

            Sorry! nothing found for

            Trip End Date Dimension

            Modified on Mon, 27 Jul at 9:44 PM

            Calendar Summary

            The Trip End Date Dimension expands the ending date stored with a QuickBooks Vehicle Mileage entry. It is the primary calendar for analyzing completed mileage trips by day, week, month, quarter, or year.

            Calendar Type

            Vehicle mileage date

            Date Represents

            Trip ending date

            QuickBooks Source

            Vehicle Mileage entry

            Primary Use

            Completed-trip analysis

            Included Data Models

            Operations: Job Cost Details, Vehicle Mileage

            QuickBooks Source

            Trip End Date comes from the ending date entered on a QuickBooks Vehicle Mileage record. It serves as the primary date for Vehicle Mileage analysis, while Trip Start Date provides the supporting beginning-date calendar.

            Source Transactions

            • Vehicle Mileage entry

            Source Example

            QuickBooks Vehicle Mileage trip end date source

            Available Fields

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

            Display OrderField Name
            1Trip End Date
            2Trip End Date Calendar Month Number
            3Trip End Date Calendar Year Number
            4Trip End Date Day Holiday Name
            5Trip End Date Day Is Holiday
            6Trip End Date Day Is Weekend Day
            7Trip End Date Day is Working Day
            8Trip End Date Day Number in Month
            9Trip End Date Day Number in Quarter
            10Trip End Date Day Number in Week
            11Trip End Date Day Number in Year
            12Trip End Date Day of Week
            13Trip End Date Day of Week Abbr
            14Trip End Date Formal Date
            15Trip End Date Month Abbr
            16Trip End Date Month Begin Date
            17Trip End Date Month End Date
            18Trip End Date Month Name
            19Trip End Date Month Number
            20Trip End Date Month Number in Quarter
            21Trip End Date Month-Year
            22Trip End Date Quarter (FQ)
            23Trip End Date Quarter (Q)
            24Trip End Date Quarter Begin Date
            25Trip End Date Quarter End Date
            26Trip End Date Quarter Number
            27Trip End Date Quarter-Year (FQ)
            28Trip End Date Quarter-Year (Q)
            29Trip End Date Week Begin Date
            30Trip End Date Week End Date
            31Trip End Date Year (FY)
            32Trip End Date Year (Y)
            33Trip End Date Year Begin Date
            34Trip End Date Year End Date
            35Trip End 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

            Let us know how can we improve this article!

            Select at least one of the reasons
            CAPTCHA verification is required.

            Feedback sent

            We appreciate your effort and will try to fix the article

            Preview
            0 of 0