Formatting the date to show the day of the week

[ChrisSedgwick]

Hi,

I'm setting up a query which will eventually run as a report to show sales within a specific date period and so on.

In my table "tblJobs" I have a field named "JobInputDate" - this will act as my date source, everything else included within the query works fine, i.e. costs etc, etc.

The format of the date field is Short Date and the default value is the date the entry was made to the table, this obviously uses the =Date() expressing to generate the date.

Now, when I come to building my query I want the dates to be shown as a day of the week, so that when I eventually build my report, I can group them by day.

I've looked through the various threads on here which all point to using the Format([YourDateField],"dddd") format. However when I run the query I get the "Data mismatch" error.

Can anyone offer any guidance?

Regards,
Chris

 

[plog]

To get the day's name, you need to use the WeekDay function (http://www.techonthenet.com/access/functions/date/weekday.php) nested inside the WeekDayName function (http://www.techonthenet.com/access/functions/date/weekdayname.php):

JobDay: WeekDayName(WeekDay(JobInputDate))

 

[CJ_London]

or use

JobDay: choose(WeekDay(JobInputDate),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")

 

[ChrisSedgwick]

Re: Formatting the date to show the day of the week [Solved]

Brilliant, this worked!

Thanks!