<div>
<a href="https://www.experts-exchange.com/articles/12318/MSSQL-Calculating-Age-in-years-right-v-wrong.html" rel="ugc">https://www.experts-exchange.com/articles/12318/MSSQL-Calculating-Age-in-years-right-v-wrong.html</a><br />
<br />
That article should help.
</div>


Developer & Coffee Roaster

Scott Fell

Founder, Kenhal

Sanjay Gandhi

<div>
Both answers can be tweaked to arrive at a combined result.<br />
However, it requires a little long code to find the answer.<br />
<br />
This is a result in years and months.<br />
Update statement is applied to update AccountAge checking AccountOpenDate compared with current date.<br />
<br />
Update Customers<br />
Set AccountAge = Str(DateDiff(YEAR,AccountO<wbr />penDate,Ge<wbr />tDate())-I<wbr />IF(Month(A<wbr />ccountOpen<wbr />Date) &lt;= Month(GetDate()),0,1),2,0)<wbr /> + 'y ' + Str(IIF(Month(AccountOpenD<wbr />ate) &lt;= Month(GetDate()), Month(GetDate())-Month(Acc<wbr />ountOpenDa<wbr />te), 12-Month(AccountOpenDate)+<wbr />Month(GetD<wbr />ate())),2,<wbr />0) + 'm'<br />
<br />
Thanks.
</div>


<div>
I assumed you wanted the age in years only.<br />
<br />
By the way, why are you storing the age in a table?
</div>


<div>
On a monthly basis, the Account age is to be calculated, so that based on age of the account, the processes can be carried out. For example, mapping some plans and sharing them with the Customers based on the age of the their account. So it will be easy to work on saved age of the Account.
</div>


<div>
If that's the case you shouldn't be updating the age every month in the table, you should use a query that returns the age and use that.
</div>


EE Topic Advisor

PortletPaul

<div>
Why not create a view that contains the age calculation?
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
In SQL Server Express 2017, I want to calculate Age in a table containing 100 records.<br />
Let us say different DOBs are saved some 25 years before today. In the new column Age, this result is desired 25y 5m 3d.<br />
<br />
-San
</div>
</div>


Hi,

In SQL Server Express 2017, I want to calculate Age in a table containing 100 records.
Let us say different DOBs are saved some 25 years before today. In the new column Age, this result is desired 25y 5m 3d.

-San

Calculate Age in SQL Server Express

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.