Data of Birth to Birthday

  • Thread starter Thread starter Harmannus
  • Start date Start date
H

Harmannus

Hallo,

How can i convert the date of birth to Birthday based on the current year?

Date of birth: 06-10-1963
Birthday: 6-10-2003

Thanx for any tips!


Regards,

Harmannus
 
Try typing this into the Field row of query design view:
DateSerial(Year(Date()), Month([Date of birth]), Day([Date of birth])
 
Back
Top