Skip to Navigation

Formula Function Reference

Our Formula Function Reference

Weeks - Durations

(Number n)
Result Type: 
Returns a Duration representing n weeks. This function takes a number and converts it into a Duration type value, expressed in weeks.
Weeks(2) returns a 2 week duration Weeks([Weeks until Delivery]) converts the numeric value in the Weeks until Delivery field into a duration expressed in weeks. The number doesn't change, just the data type.


duration type column

Hi, I´d be pleased if someone could provide me any idea of formula to

get a duration of a same date/time field but calculating with different rows.   Example:

    [Date Created] + [Date Created]{second row}- [Date Created]
{3rd row}



Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.