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.7K
Library
549
Blogs
177
Events
0
Members
46.7K
Back to discussions
Expand all
|
Collapse all
sort by most recent
sort by thread
How do I calculate if a person is 30 or under by the end of the current year?
George Bramhall
02-08-2018 00:57
How do I calculate if a person is 30 or under by the end of the current year if I know his/her birth ...
_anom Diebolt)
02-08-2018 01:42
[Over 30? By End of Year] is a Checkbox formula field with this definition: AdjustYear( [DOB] , 30) ...
George Bramhall
02-08-2018 14:50
Thank you...FYI, this calculates over 30 not under 30.
_anom Diebolt)
02-08-2018 15:07
You will have to issue an organization wide policy change to match up with my formula.
1.
How do I calculate if a person is 30 or under by the end of the current year?
1
Like
George Bramhall
Posted 02-08-2018 00:57
Reply
Reply Privately
Options Dropdown
How do I calculate if a person is 30 or under by the end of the current year if I know his/her birth date and the date of the last date of the current year? I am thinking of using a rich text formula field.
2.
RE: How do I calculate if a person is 30 or under by the end of the current year?
0
Like
_anom Diebolt)
Posted 02-08-2018 01:42
Reply
Reply Privately
Options Dropdown
[Over 30? By End of Year]
is a Checkbox formula field with this definition:
AdjustYear(
[DOB]
, 30) <= LastDayOfYear(Today())
3.
RE: How do I calculate if a person is 30 or under by the end of the current year?
0
Like
George Bramhall
Posted 02-08-2018 14:50
Reply
Reply Privately
Options Dropdown
Thank you...FYI, this calculates over 30 not under 30.
4.
RE: How do I calculate if a person is 30 or under by the end of the current year?
0
Like
_anom Diebolt)
Posted 02-08-2018 15:07
Reply
Reply Privately
Options Dropdown
You will have to issue an organization wide policy change to match up with my formula.
×
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