show weekday name only

M

Mary

Is it possible to show only the name of the day of the week?
How also would I show the name of the day, the month name, and the date
without the year?
Examples:

Thursday:

or

Thursday September 25:

I appreciate your help as I was unable to find this information as I
searched here today.
 
A

Allen Browne

To display just today's day name in a text box on a form or report, set
these properties in a text box:
Control Source =Date()
Format dddd

Use just ddd to get Thu instead of Thursday.

To get the day name, month name, and day of the month, use a format of:
dddd mmmm d

Note that internally, the date still has a year, i.e. you are manipulating
only how the date value is displayed.
 
C

croy

Is it possible to show only the name of the day of the week?
How also would I show the name of the day, the month name, and the date
without the year?
Examples:

Thursday:

or

Thursday September 25:

I appreciate your help as I was unable to find this information as I
searched here today.

Check into the DatePart function. If you can't find it in
the built-in help, search the web for Allen Browne's Access
site--I think it's him that has a good layout on working
with Dates and Times.
 
M

Mary

Thank you, very helpful!

Allen Browne said:
To display just today's day name in a text box on a form or report, set
these properties in a text box:
Control Source =Date()
Format dddd

Use just ddd to get Thu instead of Thursday.

To get the day name, month name, and day of the month, use a format of:
dddd mmmm d

Note that internally, the date still has a year, i.e. you are manipulating
only how the date value is displayed.
 
M

Mary

Thank you for your response, Croy. I did search help and saw the "datepart"
function but it didn't show me enough information to figure this out on my
own.
Have a great weekend!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top