Understand Date & Time and Mathematical expressions

Date & Time expressions

Date and time expressions let you pull important dates to the forefront of your reports, automatically calculate the number of work days it took to complete a task, or remove timestamps from view when they aren’t needed.

When looking at the available date and time expressions, you’ll find several options available.

Sample date and time expressions

There are two date and time expression sets used most often by Workfront customers:

  • ADDDAYS/ADDWEEKDAY/ADDMONTHS/ADDYEARS and
  • DATEDIFF / WEEKDAYDIFF

Mathematical expressions

Mathematical expressions allow Workfront to automatically do calculations, whether simple or complicated.

When looking at the available date and time expressions, you’ll find that you have several options available.

Sample mathematical expressions

Workfront customers commonly use these two mathematical expression sets:

  • SUB, SUM, DIV, PROD
  • ROUND

NOTE: For a full list of expressions and more information on each one, please see the “Calculated data expressions” documentation page.

recommendation-more-help
c9fbcf61-6d19-481e-a9ab-f54a0ae0ee8a