Day of the week

  • Thread starter Thread starter JJW
  • Start date Start date
J

JJW

Is there a simple way to get the actual day of the week (Sunday, Monday,
etc.) to show up in a report. I have a data entry field for date in my
table, but want the actual day to appear in the report next to the day.
 
Format(MyDateField, "ddd") will return Sun, Mon, Tue, ...

Format(MyDateField, "dddd") will return Sunday, Monday, Tuesday, ...
 
Create a new text field and link it to the date and set the format to " dddd "

Or

On the current text box you use for the date you can set the format to "
Long Date "

Either should work.

HTH

Krizhek
 

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

Similar Threads

Calculate day of week in form & store in table 2
Pivot table define Monday as first day of week 3
Show Data In Report On One Row Instead Of In A Column 2
How & Where to change the week Starting day. 3
Date for 1st day of the week 1
Finding the date of the first day of the week using "ww" to ID Wee 3
Change starting day in week form 1
MSCAL.Calendar.7 - Starting Day 2

Back
Top