birthday reminder

  • Thread starter Thread starter Tia
  • Start date Start date
T

Tia

Dear,
I have a list of employees with a list of birthdays, I'm trying to set
a birthday report to know who's birthday is today .
What formula should I use to give me the month and the day for this
year

Thank you in advance
 
?? a birthday report to know who's birthday is today
Birthday_Today: Format([DOB],"mmdd")
with criteria --
Format(Date(), "mmdd")

But that is not good - what about the person whose birthday falls on
Saturday, Sunday, Holiday, or any day the office is not open?

This for birthday today or within 5 days --
Birthdays: DateSerial(2222,Month([DOB]),Day([DOB]))
with criteria --
Between DateSerial(2222, Month(Date()), Day(Date()) AND
DateSerial(2222, Month(Date()), Day(Date())+5
 
?? a birthday report to know who's birthday is today
Birthday_Today:  Format([DOB],"mmdd")
    with criteria --
               Format(Date(), "mmdd")

But that is not good - what about the person whose birthday falls on
Saturday, Sunday, Holiday, or any day the office is not open?

This for birthday today or within 5 days --
Birthdays:  DateSerial(2222,Month([DOB]),Day([DOB]))
    with criteria --
            Between DateSerial(2222, Month(Date()), Day(Date()) AND
DateSerial(2222, Month(Date()), Day(Date())+5

--
Build a little, test a little.



Tia said:
Dear,
I have a list of employees with a list of birthdays, I'm trying to set
a birthday report to know who's birthday is today .
What formula should I use to give me the month and the day for this
year
Click to expand...
Thank you in advance
.- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

Hello i am trying to put it in the querry but i am receiving that
undefined diff 2 dates function in expression
Please help i am new in excel
 
Please help i am new in excel
The newsgroup is for Access and what I posted was for that application and
not Excel.

--
Build a little, test a little.


Tia said:
?? a birthday report to know who's birthday is today
Birthday_Today: Format([DOB],"mmdd")
with criteria --
Format(Date(), "mmdd")

But that is not good - what about the person whose birthday falls on
Saturday, Sunday, Holiday, or any day the office is not open?

This for birthday today or within 5 days --
Birthdays: DateSerial(2222,Month([DOB]),Day([DOB]))
with criteria --
Between DateSerial(2222, Month(Date()), Day(Date()) AND
DateSerial(2222, Month(Date()), Day(Date())+5

--
Build a little, test a little.



Tia said:
Dear,
I have a list of employees with a list of birthdays, I'm trying to set
a birthday report to know who's birthday is today .
What formula should I use to give me the month and the day for this
year
Click to expand...
Thank you in advance
.- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

Hello i am trying to put it in the querry but i am receiving that
undefined diff 2 dates function in expression
Please help i am new in excel
.
Click to expand...
 
Back
Top