Calculating number of days left ot my birthday

[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

 

[JohnFol]

try this
DateDiff("d", Date(), DateSerial( Year(Date()), Month(dtMyBirthday),
Day(dtMyBirthday) ) )

 

[Keith Yong via AccessMonster.com]

thanks it worked =)