Hi
I have created a database with a table that contains employee information. In one of the fields which is name fld_Employee_DOB I have inserted the employees date of birth which sits in the database in the format mm/dd/yyyy
The problem is, I want the html page to display the persons name if it is their birthday, but it only shows the birthday if the year is part of the date. What SQL statement do I use to select the day and month to display the correct information.
Any help would be appreciated.
Thanks
I have created a database with a table that contains employee information. In one of the fields which is name fld_Employee_DOB I have inserted the employees date of birth which sits in the database in the format mm/dd/yyyy
The problem is, I want the html page to display the persons name if it is their birthday, but it only shows the birthday if the year is part of the date. What SQL statement do I use to select the day and month to display the correct information.
Any help would be appreciated.
Thanks