Day of week

[Guest]

I need to calculate the day of the week for a date/time field in a query.

For example, DOW([Start Date]) would return "Wednesday" if the value for
that record were 8/9/06 00:00.

 

[Jeff Boyce]

Have you checked Access HELP? I believe there's already a function that
returns the day-of-week-name of a date.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Have you checked Access HELP? I believe there's already a function that
returns the day-of-week-name of a date.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Yes, I have been through the help over and over and can't find it. I'm
sure, too, that it exists. I've searched: "day of week", "query day" and
even "query date field" and get nothing on day of week. If you know the
function name, I'll figure it out from there. I tried "DOW([field]) and it
says "Undefined function DOW".

I need to calculate the day of the week for a date/time field in a query.

For example, DOW([Start Date]) would return "Wednesday" if the value for
that record were 8/9/06 00:00.

 

[Jeff Boyce]

WeekdayName Function


Description

Returns a string indicating the specified day of the week.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Have you checked Access HELP? I believe there's already a function that
returns the day-of-week-name of a date.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Yes, I have been through the help over and over and can't find it. I'm
sure, too, that it exists. I've searched: "day of week", "query day" and
even "query date field" and get nothing on day of week. If you know the
function name, I'll figure it out from there. I tried "DOW([field]) and
it
says "Undefined function DOW".

I need to calculate the day of the week for a date/time field in a
query.

For example, DOW([Start Date]) would return "Wednesday" if the value
for
that record were 8/9/06 00:00.

 

[John Vinson]

I need to calculate the day of the week for a date/time field in a query.

For example, DOW([Start Date]) would return "Wednesday" if the value for
that record were 8/9/06 00:00.

The function is named Weekday (rather than DOW); or you can use

=Format([Start Date], "dddd")

John W. Vinson[MVP]

 

[Allen Browne]

Jeff, perhaps we should suggest gda uses Weekday(), since WeekDayName() was
not in earlier versions, doesn't work properly in Access 2000, and gives
inconsistent results depending on your regional settings:
http://allenbrowne.com/ser-36.html#WeekdayName

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

WeekdayName Function


Description

Returns a string indicating the specified day of the week.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Have you checked Access HELP? I believe there's already a function that
returns the day-of-week-name of a date.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Yes, I have been through the help over and over and can't find it. I'm
sure, too, that it exists. I've searched: "day of week", "query day"
and
even "query date field" and get nothing on day of week. If you know the
function name, I'll figure it out from there. I tried "DOW([field]) and
it
says "Undefined function DOW".

I need to calculate the day of the week for a date/time field in a
query.

For example, DOW([Start Date]) would return "Wednesday" if the value
for
that record were 8/9/06 00:00.

 

[Jeff Boyce]

Allen

If the name of the day-of-week is needed, and WeekDayName() is inconsistent,
I'll go for recommending using Format(), with "dddd", to get the day name.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff, perhaps we should suggest gda uses Weekday(), since WeekDayName()
was not in earlier versions, doesn't work properly in Access 2000, and
gives inconsistent results depending on your regional settings:
http://allenbrowne.com/ser-36.html#WeekdayName

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

WeekdayName Function


Description

Returns a string indicating the specified day of the week.

Regards

Jeff Boyce
Microsoft Office/Access MVP

:

Have you checked Access HELP? I believe there's already a function
that
returns the day-of-week-name of a date.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Yes, I have been through the help over and over and can't find it. I'm
sure, too, that it exists. I've searched: "day of week", "query day"
and
even "query date field" and get nothing on day of week. If you know the
function name, I'll figure it out from there. I tried "DOW([field]) and
it
says "Undefined function DOW".


I need to calculate the day of the week for a date/time field in a
query.

For example, DOW([Start Date]) would return "Wednesday" if the value
for
that record were 8/9/06 00:00.