Day number to day name

[NomoreSpam4Me]

HI, i have a query that gives me the number of the day, ei: sunday is
1, monday is 2 .....saturday is 7
What i wanna do is take that 2 and bring it back to Monday. How can i
do this? IS there a way to do this in a report?? I know its easy to do
in vba, but i ask criteria in my report and each time a run it it give
me a bug......
Can i do it in a query too???

thx

[CDMAPoster]

No***********@hotmail.com wrote:

HI, i have a query that gives me the number of the day, ei: sunday is
1, monday is 2 .....saturday is 7
What i wanna do is take that 2 and bring it back to Monday. How can i
do this? IS there a way to do this in a report?? I know its easy to do
in vba, but i ask criteria in my report and each time a run it it give
me a bug......
You can cheat by using the fact that January 1, 2006 was on a Sunday.

Format(DateSerial(2006, 1, X), "dddd")

Example:
Format(DateSerial(2006, 1, 2), "dddd") => Monday
Can i do it in a query too???

thx

For a query I might use CStr to make sure it's treated as a string if I
encounter a problem.

CStr(Format(DateSerial(2006, 1, [DayNumber]), "dddd")) As DayOfWeek

James A. Fortune
CD********@FortuneJames.com

[CDMAPoster]

CD********@FortuneJames.com wrote:

No***********@hotmail.com wrote:

HI, i have a query that gives me the number of the day, ei: sunday is
1, monday is 2 .....saturday is 7
What i wanna do is take that 2 and bring it back to Monday. How can i
do this? IS there a way to do this in a report?? I know its easy to do
in vba, but i ask criteria in my report and each time a run it it give
me a bug......

You can cheat by using the fact that January 1, 2006 was on a Sunday.

Format(DateSerial(2006, 1, X), "dddd")

Example:
Format(DateSerial(2006, 1, 2), "dddd") => Monday

Can i do it in a query too???

thx

For a query I might use CStr to make sure it's treated as a string if I
encounter a problem.

CStr(Format(DateSerial(2006, 1, [DayNumber]), "dddd")) As DayOfWeek

James A. Fortune
CD********@FortuneJames.com

I also tried Format(X, "dddd") which seems to work but it gave me a bad
feeling when I used it.

James A. Fortune
CD********@FortuneJames.com

[Gina via AccessMonster.com]

If I understand correctly, you can just use the WeekDayName Function. In the
Field section of your query:

DayName: WeekdayName([DayNumber])

Gina

No***********@hotmail.com wrote:

HI, i have a query that gives me the number of the day, ei: sunday is
1, monday is 2 .....saturday is 7

What i wanna do is take that 2 and bring it back to Monday. How can i
do this? IS there a way to do this in a report?? I know its easy to do
in vba, but i ask criteria in my report and each time a run it it give
me a bug......

Can i do it in a query too???

thx

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200602/1

[CDMAPoster]

Gina via AccessMonster.com wrote:

If I understand correctly, you can just use the WeekDayName Function. In the
Field section of your query:

DayName: WeekdayName([DayNumber])

Gina

Note that that function is not part of A97.

James A. Fortune
CD********@FortuneJames.com

[MGFoster]

No***********@hotmail.com wrote:

HI, i have a query that gives me the number of the day, ei: sunday is
1, monday is 2 .....saturday is 7
What i wanna do is take that 2 and bring it back to Monday. How can i
do this? IS there a way to do this in a report?? I know its easy to do
in vba, but i ask criteria in my report and each time a run it it give
me a bug......

weekdayname(weekday(date()))

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

[Bob Quintal]

CD********@FortuneJames.com wrote in
news:11**********************@g44g2000cwa.googlegr oups.com:

Gina via AccessMonster.com wrote:

If I understand correctly, you can just use the WeekDayName
Function. In the Field section of your query:

DayName: WeekdayName([DayNumber])

Gina

Note that that function is not part of A97.

James A. Fortune
CD********@FortuneJames.com

so create it in a module
public function weekdayname( daynum as integer) as string
select case daynum
case 1
weekdayname = "Sunday"
case 7
weekdayname = "Saturday"
case else
weekdayname = "Frustrationday"
end select

end function
--
Bob Quintal

PA is y I've altered my email address.

[steve.minnaar]

I was wondering how you determined the day number in the first place. If
you already have the date which the day number refers to then to get the
day name simply use:

Format(dtMyDate,"dddd")
*** Sent via Developersdex http://www.developersdex.com ***

[NomoreSpam4Me]

yes i have a date field., i'll give each solution a try.

thx a lot, keep thos answers coming.