Home / QIN / Formula Function Reference / Weeks - Durations

Formula Function Reference

Our Formula Function Reference

Weeks - Durations

Arguments: 
(Number n)
Result Type: 
Duration
Explanation: 
Returns a Duration representing n weeks. This function takes a number and converts it into a Duration type value, expressed in weeks.
Example: 
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.
Tags:
  • 37625 reads

Comments

duration type column

Submitted by Anonymous (not verified) on Tue, 11/10/2009 - 17:37.

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}

thanks

 

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.

© 1997-2013 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit