Office Tips and Hints Blog

Home Page

Host your Web site with PureHost!

Thursday, August 28, 2008 – Permalink –

Calculate Age

A few solutions

Here are some methods that have been posted to the newsgroups:

Assuming that the birth date field is called [BDate] and is of type date, you can use the following calculation:


Age:DateDiff("yyyy", [Bdate], Now())+ _
Int( Format(now(), "mmdd")

Alternately you can use this function to calculate age:

Function Age(Bdate, DateToday) As Integer ' Returns the Age in years between 2 dates ' Doesn't handle negative date ranges i.e. Bdate > DateToday If Month(DateToday) < age =" Year(DateToday)" age =" Year(DateToday)">

From: The Access Web (MVPs.org) Also see: Support.Microsoft.com: Two Functions to Calculate Age in Months and Years

Office Tips: Martin Green Working out Someone's Age



[Edited entry from 5/15/2005]




See all Topics
Labels: Access




<Doug Klippert@ 3:01 AM
 




	
		
			Comments:
			
			
			Post a Comment 

		

	

   
   Links to this post:
   
   


       
        
       
       <$BlogBacklinkTitle$>  
      
       <$BlogBacklinkSnippet$>
       

       
       posted by <$BlogBacklinkAuthor$> @ 
       <$BlogBacklinkDateTime$>
       
       
   


   
   
Create a Link