Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Support
Quickbase University
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Home
Communities
All Posts
All Communities
My Communities
Getting Started
Events
Qrew Groups
Discussions
View Only
Community Home
Discussion
64.8K
Library
550
Blogs
177
Events
0
Members
46.8K
Back to discussions
Expand all
|
Collapse all
sort by most recent
sort by thread
How can I determine a duration between a starting date and ending date or today's date only calculating after 3yrs from the starting date?
Casameira Reyes
03-31-2017 18:29
QuickBaseCoach Dev./Training
03-31-2017 18:55
Not tested, but try this as a Formula Duration field. var date StartPlusThree = AdjustYear([Starting ...
1.
How can I determine a duration between a starting date and ending date or today's date only calculating after 3yrs from the starting date?
3
Like
Casameira Reyes
Posted 03-31-2017 18:29
Options Dropdown
2.
RE: How can I determine a duration between a starting date and ending date or today's date only calculating after 3yrs from the starting date?
0
Like
QuickBaseCoach Dev./Training
Posted 03-31-2017 18:55
Options Dropdown
Not tested, but try this as a Formula Duration field.
var date StartPlusThree = AdjustYear([Starting Date],3);
var date EndDate = if(not isnull(Ending Date]), [Ending Date]), Today());
Max(Days(0), $EndDate - $StartPlusThree)
×
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Terms and Conditions
Copyright . All rights reserved.
Powered by Higher Logic