Using Function

[raskew]

Hi All -

Got a weird situation here.

My previous post is incorrect! The days are as originally stated. My query however, instead of returning Wednesday returns Tuesday, etc..

Here's the query:

SELECT
    Members.LastName
  , Members.FirstName
  , Members.ClassTypeID
  , tblAttendance.AttendanceDate
  , [COLOR="Red"][B]Format(Day([AttendanceDate]),"dddd") AS Expr1[/B][/COLOR]
FROM
   Members 
INNER JOIN
   tblAttendance 
ON
   Members.MemberID = tblAttendance.MemberID
WHERE
   (((Members.ClassTypeID)=46))
ORDER BY
   Members.LastName
  , Members.FirstName
  , tblAttendance.AttendanceDate;

AttendanceDate is date/time Medium Date (also tried Short Date, with same results).

I'm mystified. Has anyone ever seen something like this?

Bob

 

[raskew]

For anyone interested, Gemma-the-Husky pointed out http://www.access-programmers.co.uk/forums/showthread.php?p=757964#post757964 that the format function does have a First Day of Week option, which solved this problem.

Bob

 

[eckert1961]

Hi Bob,

Just wondering if anything further was happening with this. I saw your previous posts and noted that you were making some progress but haven't seen a response from you in awhile.

Chris