[RESOLVED] dyaofweek function vba

[vbgladiator]

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,

[Hack]

How are you using it?

[vbgladiator]

dim i as integer

i = dayofweek

[Static]

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

[RobDog888]

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

[vbgladiator]

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

Thanks dude,

[Static]

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

[vbgladiator]

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

[Hack]

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.

[Static]

WAKE UP!!!

grab some more coffee man lol

[RobDog888]

I think I was the only one that read the thread

[Hack]

I think I was the only one that read the thread

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

[RobDog888]

Especially since its Resolved