[RESOLVED] dyaofweek function vba

Hey,

I'm running Access 2003 and for some reason the DayOfWeek function isn't working. If I type it in the immediate window, it returns nothing.
Has something changed?

Thanks,

How are you using it?

dim i as integer

i = dayofweek

are u trying to get the number of the day?

WeekDay()

or the name of the day?

Format(Date,"dddd")

dont recall there ever being a DayOfWeek Function?

EDIT: took too long to post.. u need the WeekDay() Funtion

Are you using it with the monthView control? If you are is it loaded on a form before calling it?

he he, never mind then. I got mixed up with vb.

Thanks dude,

just an FYI: VB doesnt have a DayOfWeek Function either..

yeah, I just realized that too. dayofweek are constants. hehe, not my day today. he he

Quote:

---

Originally Posted by vbgladiator

yeah, I just realized that too. dayofweek are constants. hehe, not my day today. he he

---

You and me both...I didn't even realize this was VBA question until DayOfWeek blew up on me as an unrecognized function. :rolleyes:

http://www.vbforums.com/

WAKE UP!!!

grab some more coffee man ;) lol

:lol: I think I was the only one that read the thread :D

Quote:

---

Originally Posted by RobDog888

:lol: I think I was the only one that read the thread :D

---

Probably. And, it seems pointless to move it to Office Development now, so..... :p

Especially since its Resolved :lol: