weekday Name Function

C

Clyde Lomax

Good evening,
Trying to get the day of the week Saturday Sunday etc.

I have the following:
day : Weekday([date_orig])
which gives the numeric 1 for Sunday and a 7 for Sunday, for the
"date_orig" field.

What would the function be for weekday name?

Thanks in advance
Lomax
 
D

dan artuso

Hi,
You could store the day as an integer and just use the dddd format to display it.
So 1 would display as Sunday.
 
D

Douglas J. Steele

Just being pedantic, but it's only a coincidence that works. 1 represents 31
Dec, 1899, which just happened to be a Sunday.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



dan artuso said:
Hi,
You could store the day as an integer and just use the dddd format to display it.
So 1 would display as Sunday.

--
HTH
Dan Artuso, MVP


Good evening,
Trying to get the day of the week Saturday Sunday etc.

I have the following:
day : Weekday([date_orig])
which gives the numeric 1 for Sunday and a 7 for Sunday, for the
"date_orig" field.

What would the function be for weekday name?

Thanks in advance
Lomax
Click to expand...
Click to expand...
 
C

Clyde Lomax

Thanks to all. for the responses.
Cheryl's worked best for my application.

Thanks again.
Lomax
dan artuso said:
Hi,
You could store the day as an integer and just use the dddd format to display it.
So 1 would display as Sunday.

--
HTH
Dan Artuso, MVP


Good evening,
Trying to get the day of the week Saturday Sunday etc.

I have the following:
day : Weekday([date_orig])
which gives the numeric 1 for Sunday and a 7 for Sunday, for the
"date_orig" field.

What would the function be for weekday name?

Thanks in advance
Lomax
Click to expand...
Click to expand...
 
Top