weekday Name Function

  • Thread starter Thread starter Clyde Lomax
  • Start date Start date
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
 
Hi,
You could store the day as an integer and just use the dddd format to display it.
So 1 would display as Sunday.
 
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...
 
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...
 
Back
Top