How do I show the 'Day' of the week

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I'm trying to set the default of a field in a table which has the
Date/Time format so that it only shows the current day ie Saturday, rather
than the date ie 18/06/2005. Can anybody offer any advice?

Les.
 
LesLdh said:
Hi, I'm trying to set the default of a field in a table which has the
Date/Time format so that it only shows the current day ie Saturday, rather
than the date ie 18/06/2005. Can anybody offer any advice?
Click to expand...

Set the format to "dddd". Mind you that will only affect what you *see*, not
what is stored. You will not be able to write queries like...

SELECT * FROM MYTable WHERE Date = "Saturday"
 
Back
Top