displaying the Day from a date

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

I have a field on my form that displays a date like 2nd April 2007 is
there a way to display the day as well

eg
Monday 2nd April 2007


Thanks very much


SImon
 
Set the Format property of the text box to:
Long Date

That should show the day and date (depending on how you have Long Date
defined in the Windows Control Panel, under Regional Settings.)

You can also show the day in another text box with the Format property set
to:
dddd
 
How are you getting 2nd April 2007? AFAIK, Access doesn't have any built-in
way to display the ordinal portion of the date (the "nd" in this case). If
you're using a function to provide that for you, modify the function to pick
up the day name using Format(YourDateValue, "dddd"). Format(YourDateValue,
"ddd") will return Mon, Tue, Wed, ...
 
Back
Top