How do I get just the weekday out of a long date

[Dave]

Access 2003

I have a query that is pulling the date from a table.
I want to know the day of the week so I changed it to "long date" in
formatting.
However this is not really what I want.

I have decided I want to pull this date twice from the table.
I want the first to be formatted long date but dropping everything but the
day of the week.

The second field will just be a short date.

How do I format the date field to just show me the day of the week.

Thanks

dave

 

[KARL DEWEY]

If you want the name of the day then use this --
Format([YourDateField], "dddd")

 

[Marshall Barton]

Access 2003

I have a query that is pulling the date from a table.
I want to know the day of the week so I changed it to "long date" in
formatting.
However this is not really what I want.

I have decided I want to pull this date twice from the table.
I want the first to be formatted long date but dropping everything but the
day of the week.

The second field will just be a short date.

How do I format the date field to just show me the day of the week.

Format(datefield, "dddd")

 

[Dave]

Thank you both
dddd - was exactly what I was looking for

dave

If you want the name of the day then use this --
Format([YourDateField], "dddd")
--
Build a little, test a little.

Access 2003

I have a query that is pulling the date from a table.
I want to know the day of the week so I changed it to "long date" in
formatting.
However this is not really what I want.

I have decided I want to pull this date twice from the table.
I want the first to be formatted long date but dropping everything but
the
day of the week.

The second field will just be a short date.

How do I format the date field to just show me the day of the week.

Thanks

dave