Calculating number of days left ot my birthday

  • Thread starter Thread starter Keith Yong via AccessMonster.com
  • Start date Start date
K

Keith Yong via AccessMonster.com

Hi,

Given the date of birth and the system date in dd/mm/yyyy format, how do i calculate the number of days left to my birthday?

ie: If my DOB is 16/08/1968 and system date is 20/08/2005, how do i get the expression to calculate the number of days to my birthday be 4?

thanks a million
 
try this
DateDiff("d", Date(), DateSerial( Year(Date()), Month(dtMyBirthday),
Day(dtMyBirthday) ) )
 
Back
Top