|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 24th, 2009, 06:14 PM
posted to microsoft.public.access.forms
|
|||
|
|||
birthday reminder
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 
|
|
#2
October 25th, 2009, 01:56 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
birthday reminder
?? 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" wrote: 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 .
|
|
#3
October 25th, 2009, 06:58 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
birthday reminder
On Oct 25, 5:56*am, KARL DEWEY
wrote: ?? 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" wrote: 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 .- Hide quoted text - - Show quoted text - 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
|
|
#4
October 26th, 2009, 03:19 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
birthday reminder
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" wrote: On Oct 25, 5:56 am, KARL DEWEY wrote: ?? 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" wrote: 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 .- Hide quoted text - - Show quoted text - 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 .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
