Display the current Day

[gselliott]

I am wanting to set up an Update query that will display the current day (eg Monday) I have managed to set up the date and time but not sure how go about showing the day.

Any help is appreciated.

Thanks

 

[Mile-O]

Why would you need an UPDATE query?

 

[gselliott]

The query will be used to update my table with the current user information when they run a particular procedure on the form.

 

[Mile-O]

But you already have the date. What you are asking for is to store a calculated value in a table which is a database no-no! You rtitle, however, alludes to only displaying which is what you should be doing if you need to display the day (which is easily got from the date).

i.e.

=Format(Date(), "dddd")

 

[Rich]

stick to storing the date, you only need to set the format display of the control to dddd, to display the day

 

[gselliott]

Thanks to both of you for your help I don't think I explained properly what I was trying to do but the format dddd does exactly what I need!

Thanks again.