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.
|
|
0
|
|
|
|
Reply
|
 Utf
|
1/3/2008 4:41:05 PM |
|
Using DOB as the employee's birthday:
Format(DateSerial(Year(Date),Month(DOB),Day(DOB)),"dddd")
--
Dave Hargis, Microsoft Access MVP
"Victoria@DIG" wrote:
> 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.
|
|
|
0
|
|
|
|
Reply
|
Utf
|
1/3/2008 5:02:04 PM
|
|
It worked! Thanks.
"Klatuu" wrote:
> Using DOB as the employee's birthday:
> Format(DateSerial(Year(Date),Month(DOB),Day(DOB)),"dddd")
> --
> Dave Hargis, Microsoft Access MVP
>
>
> "Victoria@DIG" wrote:
>
> > 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.
|
|
|
0
|
|
|
|
Reply
|
Utf
|
1/3/2008 5:58:04 PM
|
|
Glad I could help.
--
Dave Hargis, Microsoft Access MVP
"Victoria@DIG" wrote:
> It worked! Thanks.
>
> "Klatuu" wrote:
>
> > Using DOB as the employee's birthday:
> > Format(DateSerial(Year(Date),Month(DOB),Day(DOB)),"dddd")
> > --
> > Dave Hargis, Microsoft Access MVP
> >
> >
> > "Victoria@DIG" wrote:
> >
> > > 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.
|
|
|
0
|
|
|
|
Reply
|
Utf
|
1/3/2008 6:01:02 PM
|
|
|
3 Replies
475 Views
(page loaded in 0.038 seconds)
Similiar Articles: week of the year - microsoft.public.access.formscodingNumber of the day of the year - microsoft.public.excel.misc ... How to find which day of the week, this year, a birthday fall ... Number of the day of the year - microsoft ... Days of the Week AutoCorrect options - microsoft.public.word ...I'm trying to figure out where/how Word 2007 stores AutoCorrect entries, for the Day-of-the-Week, and Month. It's not that we want to turn it off ... Interval between now and next birthday - microsoft.public.excel ...How to find which day of the week, this year, a birthday fall ..... month has at least 29 days) the 29th. The years, taken at ten-year intervals ... trick given below ... How do I find how many of a certain day are in a given month ...How to find which day of the week, this year, a birthday fall ... How to find which day of the week, this year, a birthday fall ... Select whose birthday is in a certain ... Number of the day of the year - microsoft.public.excel.misc ...... year - microsoft.public.access.formscoding Number of the day of the year - microsoft.public.excel.misc ... How to find which day of the week, this year, a birthday fall ... Select whose birthday is in a certain month - microsoft.public ...How to find which day of the week, this year, a birthday fall ... Select whose birthday is in a certain month - microsoft.public ... How to find which day of the week ... Querying Date Field, Disregarding Year - microsoft.public.access ...How to find which day of the week, this year, a birthday fall ... I have a query I use to inform the managers what birthdays are upcoming in their ... Query from day of week - microsoft.public.access.queries ...How to find which day of the week, this year, a birthday fall ... Hello: I have a database with employee birthdays. (I enter all the birthdays as mm/dd/1900 so no one ... Calculating How Old Someone Will Be in a certain year - microsoft ...How to find which day of the week, this year, a birthday fall ..... mm/dd/1900 so no one knows how old ... microsoft.public.excel ..... calculate the interval between a ... calculate weeks within quarter - microsoft.public.access.queries ...... want to run a > query and have it return the starting day of the week, or just the > weeknumbers that fall ... Fiscal Year Week Number Calculation with a twist ... How to find which day of the week, this year, a birthday fall ...DataBase - How to find which day of the week, this year, a birthday fall? PHP Day of the Week - Find what day of the week events fall on ...What Day of the Week Does it Fall on? Find out what day of ... others vary every year. If you want to find out what day of the week Halloween, Christmas, or even your birthday ... How to Determine the Day of the Week From the Date | eHow.comBirthdays by Age; Birthday Ideas for 12 Year Olds; How to Determine the Day of the Week From the Date ... Aug. 8 and Oct. 10 all fall on the same day of the week each year. The ... Learn what day you were born on - MaxxSystems -- Website Hosting ...What Day's Your Birthday? Numeric Month (1-12): Day of Month (1-31): Year (eg. 1980): Birth Date: Day of the Week: How to Calculate the Day of the Week: 9 steps - wikiHowThe years, taken at ten-year intervals, fall into a pattern ... one from Year-day of the (larger) normal year. With more practice, you could quickly find the day of the week ... 7/24/2012 1:06:44 PM
|
Search |
Post Question |
Groups |
Stream |
About |
Register
16 followers. 