Reporting Birthdays

I have a "date of birth (DOB)" field in a table. How to I get a report (or query?) to only show/return folks with birthdays within the next 30 days.

Thanks
Greg

Hi Greg.
Using a query for your report in the DOB column criteria
enter = Now() and (Now()+31)
Hope this helps
Fons
-----Original Message-----
I have a "date of birth (DOB)" field in a table. How to
I get a report (or query?) to only show/return folks with
birthdays within the next 30 days.

Thanks
Greg
.

In your query enter the following as the criteria of your "date of birth"
field:

Between Date() And Date()+"30"


"turbogreg17" wrote in message
...
I have a "date of birth (DOB)" field in a table. How to I get a report
(or query?) to only show/return folks with birthdays within the next 30
days.

Thanks
Greg

Ummmmm, Fons. That won't work unless you are looking for birthdates of
unborn babies :-)

You need to limit your criteria to only look at the month and day.

Rick B

"Fons Ponsioen" wrote in message
...
Hi Greg.
Using a query for your report in the DOB column criteria
enter = Now() and (Now()+31)
Hope this helps
Fons
-----Original Message-----
I have a "date of birth (DOB)" field in a table. How to
I get a report (or query?) to only show/return folks with
birthdays within the next 30 days.

Thanks
Greg
.

I think you would need to add a new column to your query to pull the month
and day only. then in the criteria you would pull between the month and day
of the cuttent month, and the month and day of the current month +30.

Rick B


"turbogreg17" wrote in message
...
I have a "date of birth (DOB)" field in a table. How to I get a report (or
query?) to only show/return folks with birthdays within the next 30 days.

Thanks
Greg

Boy, did I goof. I did ignore the fact that the date is
past.
How about this resolution.
Create a new column in the query with:
TempDate: Month([DOB]) & "/" & Day([DOB]) & "/" & Year(Now
())
all on one line.
than set the citeria for this column like I did or like:
between Now() and Now()+30
Hope I redeemed my self (a little)
Fons
-----Original Message-----
I think you would need to add a new column to your query
to pull the month
and day only. then in the criteria you would pull
between the month and day
of the cuttent month, and the month and day of the
current month +30.

Rick B


"turbogreg17"
wrote in message
...
I have a "date of birth (DOB)" field in a table. How to
I get a report (or
query?) to only show/return folks with birthdays within
the next 30 days.

Thanks
Greg


.

On Wed, 21 Jul 2004 11:47:02 -0700, turbogreg17 wrote:

I have a "date of birth (DOB)" field in a table. How to I get a
report (or query?) to only show/return folks with birthdays within
the next 30 days.

Thanks Greg

Where Format([DOB],"mm/dd") between Format(Date(),"mm/dd") AND
Format(Date()+30,"mm/dd")

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Fons (all),
Thanks for the help. I got the TempDate column set in the DOB query using "TempDate: Month([DOB]) & "/" & Day([DOB]) & "/" & Year(Now())"
and it works...it converts 8/4/1960 to 8/4/2004 in a temp column.

....however I can't seem to get the citeria to work (that should be the simple part I would think).
I tried all suggested syntax, e.g. your suggestions " between Now() and Now()+30 " and " = Now() and (Now()+31) ", and JWM's suggestion of " Between Date() And Date()+30 ". ...but syntax ends up filtering out dates that should show (such as my 8/4/2004). Also tried putting the "day" before the "month" as in "TempDate: Day([DOB]) & "/" & Month([DOB]) & "/" & Year(Now())"...thought that might work...but no good. Any suggestions as to what could be going on?
Fell like I'm almost there!

Thanks
Greg

"Fons Ponsioen" wrote:

Boy, did I goof. I did ignore the fact that the date is
past.
How about this resolution.
Create a new column in the query with:
TempDate: Month([DOB]) & "/" & Day([DOB]) & "/" & Year(Now
())
all on one line.
than set the citeria for this column like I did or like:
between Now() and Now()+30
Hope I redeemed my self (a little)
Fons
-----Original Message-----
I think you would need to add a new column to your query
to pull the month
and day only. then in the criteria you would pull
between the month and day
of the cuttent month, and the month and day of the
current month +30.

Rick B


"turbogreg17"
wrote in message
...
I have a "date of birth (DOB)" field in a table. How to
I get a report (or
query?) to only show/return folks with birthdays within
the next 30 days.

Thanks
Greg


.

You did set the criteria in the column under the TempDate
I hope. I have tried it here with both approaches and it
works fine.
between Now() and Now()+30
or
Between Date() And Date()+30
Hope we get you going.
Fons

-----Original Message-----
Fons (all),
Thanks for the help. I got the TempDate column set in
the DOB query using "TempDate: Month([DOB]) & "/" & Day
([DOB]) & "/" & Year(Now())"
and it works...it converts 8/4/1960 to 8/4/2004 in a
temp column.

....however I can't seem to get the citeria to work (that
should be the simple part I would think).
I tried all suggested syntax, e.g. your suggestions "
between Now() and Now()+30 " and " = Now() and (Now()
+31) ", and JWM's suggestion of " Between Date() And Date()
+30 ". ...but syntax ends up filtering out dates that
should show (such as my 8/4/2004). Also tried putting
the "day" before the "month" as in "TempDate: Day([DOB])
& "/" & Month([DOB]) & "/" & Year(Now())"...thought that
might work...but no good. Any suggestions as to what
could be going on?
Fell like I'm almost there!

Thanks
Greg

"Fons Ponsioen" wrote:

Boy, did I goof. I did ignore the fact that the date
is
past.
How about this resolution.
Create a new column in the query with:
TempDate: Month([DOB]) & "/" & Day([DOB]) & "/" & Year
(Now
())
all on one line.
than set the citeria for this column like I did or like:
between Now() and Now()+30
Hope I redeemed my self (a little)
Fons
-----Original Message-----
I think you would need to add a new column to your
query
to pull the month
and day only. then in the criteria you would pull
between the month and day
of the cuttent month, and the month and day of the
current month +30.

Rick B


"turbogreg17"
wrote in message
news:68A9B9D2-76C5-43C8-B050-
...
I have a "date of birth (DOB)" field in a table. How
to
I get a report (or
query?) to only show/return folks with birthdays
within
the next 30 days.

Thanks
Greg


.


.

Yup, even re-did the query from scratch. Working with a simple query in order to get it running. Here is what I have...the query pulls from my "main info" table and is only 3 columns: "LastName", "DOB" and your "TempDate". No sorts or other criteria in any column. I even switched my data type in the feeder table to short date from medium date...(thinking it might be the problem).

Date conversion to to this year using "Year(Now())" works fine when no criteria is set...even from a medium date; 4-Aug-60 converts to 84/2004. The critieria should pick that date up with the between now() or date() syntax.

I'm stumped!

"Fons Ponsioen" wrote:

You did set the criteria in the column under the TempDate
I hope. I have tried it here with both approaches and it
works fine.
between Now() and Now()+30
or
Between Date() And Date()+30
Hope we get you going.
Fons

-----Original Message-----
Fons (all),
Thanks for the help. I got the TempDate column set in
the DOB query using "TempDate: Month([DOB]) & "/" & Day
([DOB]) & "/" & Year(Now())"
and it works...it converts 8/4/1960 to 8/4/2004 in a
temp column.

....however I can't seem to get the citeria to work (that
should be the simple part I would think).
I tried all suggested syntax, e.g. your suggestions "
between Now() and Now()+30 " and " = Now() and (Now()
+31) ", and JWM's suggestion of " Between Date() And Date()
+30 ". ...but syntax ends up filtering out dates that
should show (such as my 8/4/2004). Also tried putting
the "day" before the "month" as in "TempDate: Day([DOB])
& "/" & Month([DOB]) & "/" & Year(Now())"...thought that
might work...but no good. Any suggestions as to what
could be going on?
Fell like I'm almost there!

Thanks
Greg

"Fons Ponsioen" wrote:

Boy, did I goof. I did ignore the fact that the date
is
past.
How about this resolution.
Create a new column in the query with:
TempDate: Month([DOB]) & "/" & Day([DOB]) & "/" & Year
(Now
())
all on one line.
than set the citeria for this column like I did or like:
between Now() and Now()+30
Hope I redeemed my self (a little)
Fons
-----Original Message-----
I think you would need to add a new column to your
query
to pull the month
and day only. then in the criteria you would pull
between the month and day
of the cuttent month, and the month and day of the
current month +30.

Rick B


"turbogreg17"
wrote in message
news:68A9B9D2-76C5-43C8-B050-
...
I have a "date of birth (DOB)" field in a table. How
to
I get a report (or
query?) to only show/return folks with birthdays
within
the next 30 days.

Thanks
Greg


.


.