Skip to main content

Solutions

Law firms

Tax, audit & accounting firms

Corporations

Governments

Products

Legal

Trade & supply

Tax, audit & accounting

Corporate tax

Risk & fraud

Books

Recommended products

Questions? We are here to help.
Contact us

Purchase

Buy solutions

Buy books

Contact sales

Questions? We are here to help.

Resources

Insights

Events

Product training

Product communities

Developers

Time and Expense

Practice CS: Date Span & Time Span Formulas

In the Practice CS Custom Formats screen, you can calculate the amount of time between dates and times by using a Date Span or Time Span formula.
When working with these formulas, create a copy of your custom format and work in the copy to preserve your original format.
Date Span
 A date span formula calculates the number of years, months, weeks, or days between 2 dates. Any date output formula can be utilized. The following are currently the available formulas:
  • [Date Span("Year", Minimum Date, Maximum Date)]
  • [Date Span("Quarter", Minimum Date, Maximum Date)]
  • [Date Span("Month", Minimum Date, Maximum Date)]
  • [Date Span("Week", Minimum Date, Maximum Date)]
  • [Date Span("Day", Minimum Date, Maximum Date)]
Time Span
 A time span formula calculates the number of hours, minutes, or seconds between 2 times. The following are currently the available formulas:
  • [Time Span("Hour", Minimum Date, Maximum Date)]
  • [Time Span("Minute", Minimum Date, Maximum Date)]
  • [Time Span("Second", Minimum Date, Maximum Date)]
Both the
Date Span
 and
Time Span
 formulas can be located in the
System Formulas
 under
Date Parts
 in the selection tree. The "Minimum Date" can be replaced by the oldest or "from" date desired. The "Maximum Date" can be replaced by the most recent or "to" date desired.
Example
 You would like to see the number of days since a Project was received. On the Project Listing report, you add a new column called "Days In" and use the following formula: [Date Span("Day", Project received date(Project), Today's Date)] If a project was received on 4/1/2013 and I run the report on 4/12/2013, the number of Days In will be 12.

This article applies to:

  • Product: Practice CS