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]

Re: Does MA Access have a Calendar Function?

On Mon, 29 Dec 2003 18:32:56 -0500, Todd D. Levy
<usenet001-tdlevy@spamex.c om> wrote:
[color=blue]
>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?[/color]

Format(SomeDate ,"ddd")

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

- Jim

[fredg]

Re: Does MA Access have a Calendar Function?

Todd D. Levy wrote:
[color=blue]
> 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?[/color]

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]

Re: Does MA Access have a Calendar Function?

Thank You everyone.