EBSuite Support  shadow  Knowledge & FAQs    Learning Center  shadow  Tech Blog  shadow  Support Question?  shadow  Login to Case History  shadow
 


Knowledge Home | Functional Area | Admin & Setup |
Is there a way to use a calculated number field to determine a number of years?

[Q] Is there a way to use a calculated number field to determine a number of years?
Here is what I desire:
A. Add/ a field (Field A) and track the graduation year from college ( example 1988 )
B. Add another field (Field B) (calcuted ) that says "Years since graduation"
C. The logic for Field B = today's year - Field A
This functionality would let me store a calculated amount and run queries/send reports for ten year anniversaries, 25 year graduation, 16th birthday, 21st birthday, etc.


[A] Yes, you can use the "TODAY_YEAR" (without "") keyword in the constant field of a calculated custom field.

  • Define a custom field of type ?Number/Calculated?.
  • After submit, you will see an ?edit? next to the newly created ?Number/Calc? field.
  • Click into the edit link, and you will have a chance to define

[LEFT] (+-*/) [RIGHT].


  • Put (all caps) "TODAY_YEAR" (without"")  as the left value.
  • For example in the following screenshot

    The field value will be 9.00, (right now is 2009)


date calculation, years
 

Related Articles:
No related articles.
 
Attachments:
No attachment found for this article.
 
Was this article helpful?
 
 
Type: Knowledge Base
Email a friend
Print this page


Back to Knowledge & FAQs page.


 
 
Powered by EBSuite.