asked on Need age at date of document
Hi,
I have two date time fields. One represents the birth date of the person, the other the date of the document.
I need to know at the date of the document how old the person was.
CREATE TABLE [dbo].[tbl_account_documen
[account_number] [varchar](12) NULL,
[doc_date] [datetime] NULL,
[date_of_birth] [datetime] NULL
) ON [PRIMARY]
I have two date time fields. One represents the birth date of the person, the other the date of the document.
I need to know at the date of the document how old the person was.
CREATE TABLE [dbo].[tbl_account_documen
[account_number] [varchar](12) NULL,
[doc_date] [datetime] NULL,
[date_of_birth] [datetime] NULL
) ON [PRIMARY]
Microsoft SQL Server
Last Comment
Charles Baldo
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you
another method (a case expression decides if you need to deduct 1 or not)
DECLARE @date_of_birth datetime
SET @date_of_birth ='1937-08-10 00:00:00'
select
@date_of_birth
, YEAR(getdate()) - YEAR(@date_of_birth)
- ( CASE
WHEN MONTH(@date_of_birth) > MONTH(getdate())
OR ( MONTH(@date_of_birth) = MONTH(getdate())
AND DAY(@date_of_birth) > DAY(getdate())
)
THEN 1
ELSE 0
END ) AS Reliable_Age
ASKER
Thank You, a minor variation of Jims did work, appreciate your solution though and will keep it in the "Bag of Tricks"
SELECT DATEDIFF(YEAR, doc_date, date_of_birth) AS AgeAtDocCreation