How to find which day of the week, this year, a birthday fall?

[Victoria@DIG]

Hello:

I have a database with employee birthdays. (I enter all the birthdays as
mm/dd/1900 so no one knows how old anyone is.) I have a query I use to
inform the managers what birthdays are upcoming in their department. It so
happens that 2007 had the same calendar as 1900 so I didn't realize I wasn't
pulling the day of the week the birthday falls for the current year.

Is there an expression I need to build or a particular format I need to set?
I was using the number format dddd, mm/dd.

Thanks.

 

[Klatuu]

Using DOB as the employee's birthday:
Format(DateSerial(Year(Date),Month(DOB),Day(DOB)),"dddd")

 

[Victoria@DIG]

It worked! Thanks.

Using DOB as the employee's birthday:
Format(DateSerial(Year(Date),Month(DOB),Day(DOB)),"dddd")

 

[Klatuu]

Glad I could help.