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

  • Thread starter Thread starter Dave
  • Start date Start date
D

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
 
Dave said:
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.
Click to expand...


Format(datefield, "dddd")
 
Thank you both
dddd - was exactly what I was looking for

dave



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


Dave said:
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
Click to expand...
Click to expand...
 
Back
Top