Query and filtering dates

[robert]

I have a date field named dateFIELD in my database whose output or
display is a LONG DATE and the input mask is a SHORT DATE:

I type: 08/31/2006
Access enters: Thursday, August 31, 2006

In a query if I type Day([dateFIELD]) i get 31, what is the formula to
return Saturday, instead of 31? Or is there a formula to return the
actual name of the day rather than the number of the day?

Thanks in advance.

 

[CompGeek78]

Use weekdayname(weekday([dateFIELD]))

Keven

 

[Allen Browne]

It might be better to use:
Format([dateFIELD], "dddd")
since that works in all versions of Access, and with all regional settings.

WeekdayName() has several problems:
- fails in Access 97 and earlier,
- unreliable in Access 2000, and
- gives wrong results in some regional settings.

Details:
http://allenbrowne.com/ser-36.html#WeekdayName

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Use weekdayname(weekday([dateFIELD]))

Keven

I have a date field named dateFIELD in my database whose output or
display is a LONG DATE and the input mask is a SHORT DATE:

I type: 08/31/2006
Access enters: Thursday, August 31, 2006

In a query if I type Day([dateFIELD]) i get 31, what is the formula to
return Saturday, instead of 31? Or is there a formula to return the
actual name of the day rather than the number of the day?

Thanks in advance.

 

[CompGeek78]

Crazy, I've never seen issues with the WeekdayName function before, but
after reading your article and trying some of those things out...I'm
amazed. Thanks for the correction, I'll stop using the weekdayname
function.

It might be better to use:
Format([dateFIELD], "dddd")
since that works in all versions of Access, and with all regional settings.

WeekdayName() has several problems:
- fails in Access 97 and earlier,
- unreliable in Access 2000, and
- gives wrong results in some regional settings.

Details:
http://allenbrowne.com/ser-36.html#WeekdayName

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Use weekdayname(weekday([dateFIELD]))

Keven

I have a date field named dateFIELD in my database whose output or
display is a LONG DATE and the input mask is a SHORT DATE:

I type: 08/31/2006
Access enters: Thursday, August 31, 2006

In a query if I type Day([dateFIELD]) i get 31, what is the formula to
return Saturday, instead of 31? Or is there a formula to return the
actual name of the day rather than the number of the day?

Thanks in advance.

 

[robert]

You guys are the greatest! Thanks for the code, now I have to remember
where I needed to use it?!!!!!!

Thanks!
Rob