|  Organizer Advantage HowTo/Help  |  Designer HowTo/Help  | 

Designer Help > Build Database Simple > Automatically calculate anniversary value, such as age or years

How can I create a numerical field that automatically calculates the anniversary value, such as age or years?

This simple table sample illustrates how to input essential details of an event, including the date it occurred. The program is designed to automatically calculate the anniversary based on this date, streamlining the tracking of important milestones.

Anniversaries:

• Marriage Anniversary
• Birthday Anniversary
• Graduation Anniversary
• Engagement anniversary
• Moving anniversary
• Retirement anniversary
• First date anniversary
• Anniversary of a significant life event (like a survival or overcome challenge)
• Anniversary of a founding (for businesses or organizations)
• Anniversary of a friendship
• Death Anniversary
• Wedding anniversary

Inventory/Asset Table
We enter data about events into the simple table. The structure of this table is as follows:
ID:Integer:
TITLE_NAME:Text:40
CATEGORY:Text:40
EVENT_DATE:Date:
ANNIVERSARY_AGE:Numeric:
NOTES:Memo:

How can I create a numerical field that automatically calculates the anniversary value, such as age or years?

• Start the Designer and select the Invoice table.
• Open the Layout page (1) and activate Design Mode (2).
• Click on the ANNIVERSARY_AGE box (3) to select it, then click on Modify Control Attributes (4) to display the Set Control Attributes options.
• Click on SQL Query (5) and enter "DATEDIFF(month, EVENT_DATE, CURRENT_DATE)/12".
• To save your definitions, click Save (6) and Save Layout (7).

Organizer Advantage, Simple Database Solutions for Windows PC

Organizer Advantage, Business Database Solutions for Windows PC

Organizer Advantage Free Service

Organizer Advantage Support