Day of the week

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.
 
D

Douglas J Steele

Format(MyDateField, "ddd") will return Sun, Mon, Tue, ...

Format(MyDateField, "dddd") will return Sunday, Monday, Tuesday, ...
 
G

Guest

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
Creating a date from week number, day number and year value 1
Finding the date of the first day of the week using "ww" to ID Wee 3
Change starting day in week form 1
Day of Week 3
Date for 1st day of the week 1
MSCAL.Calendar.7 - Starting Day 2

Top