Question:

How to show the value difference between the values of two Datetime fields on an object in Veeva Align?

Answer:

1. Create a new custom Formula field on the Object.
   Navigate to: Admin --> Configuration --> Select the Object --> Create new field.
2. Set the Return Type to Number.
3. Enter the Formula Expression of the custom field into the Formula Expression section, which will get evaluated to return the resulting value of the subtraction. (Later End Date Time - Earlier End Date Time).
   The result will be in the measure of days.
4. To get the value in Hours: Multiply the formula by 24.
5. To get the value in Minutes: Multiply the formula by 1440. (24x60)
6. To get the value in Seconds: Multiply the formula by 86400. (24x60x60)

Example:

This field shows the difference between the Creation DateTime and the End DateTime fields on the Process Task object in seconds.

Related Documentation:

Align Help Documentation: N/A