How do I show the 'Day' of the week

[LesLdh]

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.

 

[Rick Brandt]

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?

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"