day of the week

I

ian

can somebody tell me the expressin to put into a query so
I get the day of the week (mon, tues, etc..) from a date
field.

the date field is called [createdate]
 
C

Cheryl Fischer

Format([CreateDate],"ddd") will return Mon, Tues, etc.

Format([CreateDate],"dddd") will return Monday, Tuesday, etc.
 
W

Wayne Morgan

There are a couple of ways. You will need to make a calculated field in the
query.

Example
NameOfDay:Format([CreateDate], "ddd")
or
NameOfDay:WeekdayName(WeekDay([CreateDate], True)

The True in the second statement means to use the abbreviation (i.e. Wed),
if you use False you'll get the full name (i.e. Wednesday). To get the full
name in the first example change "ddd" to "dddd".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter a Multi-value combo box field based on data entered in the 6
How to display database in a calendar format 22
convert date to Day of the Week 2
MainForm(weekly) detail of week sched. in Subform 2
Query expression... 4
Pivot table define Monday as first day of week 3
weekday 1
Converting Text to Date 1

Top