troubleshooting Question

Need age at date of document

Avatar of Charles Baldo
Charles BaldoFlag for United States of America asked on
Microsoft SQL Server
5 Comments1 Solution113 ViewsLast Modified:

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_documents](
      [account_number] [varchar](12) NULL,
      [doc_date] [datetime] NULL,
      [date_of_birth] [datetime] NULL
Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros