Match Today's Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I keep personnel information in several tables. One of the things that has
been requested is to put on our intranet when it is someone's birthday. I
have that information. What I do not know how to do is to construct the
query to only display the birthdays for today.

I could put in a parameter to ask the date and then match that against the
table. But because this query is going to be displayed via a web page,
prompting for the date is not going to work.

What I envision is FP loading the query. If there is a match for today's
date, it will display that it is John Smith's birthday. If there are no
matches, nothing will display.

I am using Access 2003/FP 2003/IIS 6.x.

I appreciate any help that you can offer.
 
You would need a new column in your query to pull the month and day of the
birthdate. Then, in the criteria, you can tell it to grab the month and
date of today's date...


New column...
BirthdayMD: Format([BDayFieldName],"mmdd")

Criteria...
=Format(Date(), "mmdd")


Obviously, you would need to replace [BDayFieldName] with the name of your
field.

Hope that helps,

Rick B
 
Back
Top