Day of Week Function?

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

Guest

Hello:

I've been searching everywhere for a simple Access 2000 function that is the
equvialent of the CDOW() function in Alpha Five. For example, there is a
Date_Work field and I want to add a 2nd field to the form that displays the
day of the week, i.e. Wednesday.

In Alpha Five, it would be CDOW(Date_Work)

If the date were 05/24/2005, the field would display Tuesday.

Thanks,
Robert
 
Robert said:
Hello:

I've been searching everywhere for a simple Access 2000 function that
is the equvialent of the CDOW() function in Alpha Five. For example,
there is a Date_Work field and I want to add a 2nd field to the form
that displays the day of the week, i.e. Wednesday.

In Alpha Five, it would be CDOW(Date_Work)

If the date were 05/24/2005, the field would display Tuesday.

Thanks,
Robert
Click to expand...

=Format(Date_Work, "dddd")
 
Hello Rick:

Thanks so much, it worked perfectly.

I looked everywhere I could think of in the help pages and online, but
couldn't find that function. I checked the topic Date Functiions, Day of Week
Functions, etc. but couldn't find it. Do you know what I did wrong?

Thanks again,
Robert
 
Robert said:
Hello Rick:

Thanks so much, it worked perfectly.

I looked everywhere I could think of in the help pages and online, but
couldn't find that function. I checked the topic Date Functiions, Day
of Week Functions, etc. but couldn't find it. Do you know what I did
wrong?

Thanks again,
Robert
Click to expand...

Since Access 2000 and upward the help files have been terrible for finding
things. While getting better in each version since 2000 they are still not
as easy to search as A97 was. In many cases you need to look in VBA help
rather than Access help.
 
Hi Rick:

Thanks for the confirmation on the poor organization of the Access Help
File. One would think the function I needed would be listed under the overall
category of DATE related functions. I still find it hard to believe someone
can't see something so obvious.

Robert
 
Back
Top