A field that returns the weekday from a date field on a form in MS Access or VBA?

Question

I have a field on a form which requires a date input in Microsoft Access. I want to create a new field on the form which will return just the weekday from the date entered in the date field.

Can somrebody help me please!!!

Answer 1

It's a re-format of the date.

For abbreviated (Mon, Tue, Wed...)
=Format([<
For full:
=Format([<

Answer 2

i think of you will possibly be able to desire to jot down some get entry to straightforward interior the administration source of the sphere in layout view of your type. some thing like If Date() <> [Fieldname with date] than [status container].text cloth="expired". The syntax isn't in basic terms right however the assumption is to evaluate modern date to a date inserted in a container and alter the content cloth of yet another container for that reason. Makiavel