Does MA Access have a Calendar Function?

[Todd D. Levy]

I want to be able to determine (from a date entered by the user) what
the Day of the Week is for that date.

Does MS Access have that function?

If it makes any difference, I am using Access 2002, but with Access 2000
file format for backward compatibility.

If not, can anyone recommend a 3rd party control that can be purchased
for a reasonable price?

[Jim Allensworth]

On Mon, 29 Dec 2003 18:32:56 -0500, Todd D. Levy
<us**************@spamex.com> wrote:

I want to be able to determine (from a date entered by the user) what
the Day of the Week is for that date.

Does MS Access have that function?

If it makes any difference, I am using Access 2002, but with Access 2000
file format for backward compatibility.

If not, can anyone recommend a 3rd party control that can be purchased
for a reasonable price?

Format(SomeDate,"ddd")

Try it in the debug window:
?Format(date(),"ddd")
Mon

- Jim

[fredg]

Todd D. Levy wrote:

I want to be able to determine (from a date entered by the user) what
the Day of the Week is for that date.

Does MS Access have that function?

If it makes any difference, I am using Access 2002, but with Access 2000
file format for backward compatibility.

If not, can anyone recommend a 3rd party control that can be purchased
for a reasonable price?

The Day Number?
For today (12/29/2003, Monday) assuming Sunday is weekday 1.

=Weekday(Date())
2

or the actual day?

=Format(Date(),"dddd")
Monday

Look up the Format property in Access help and the Format() function in
VBA help, as well as the WeekDay() function in VBA Help.
--
Fred
Please reply only to this newsgroup.
I do not respond to personal e-mail.

[Todd D. Levy]

Thank You everyone.