how to display day of week

[Jason]

i tried day(date) but that displays day of month. I tried help for
access 97 but help can't find veenlr3.hlp

Thanks,
Jason

 

[Jason]

found on the internet.
But is there a if inrange (0,15,30,45) instead of using if a=0 or a=15
or a=30 or a=45?

 

[Rick Brandt]

i tried day(date) but that displays day of month. I tried help for
access 97 but help can't find veenlr3.hlp

=Format(Date,"dddd")

 

[Pat Hartman]

There are several ways to get the name of the weekday. Here"s two

Format(Date,"dddd")- the Format() function belongs in everyone's repertoire . It is used to format dates and numbers.

WeekDayName(Weekday(Date)) = this uses the WeekDay function to return the numeric day of the week (1-7) and then WeekDayName takes the value 1-7 and returns a day of the week.

You can adjust the starting day of the week with several of these functions. Take a look at the help entries for details.

Submitted via EggHeadCafe
Microsoft ASP.NET For Beginners
http://www.eggheadcafe.com/training-topic-area/ASP-NET/7/ASP.aspx

 

[Jason]

Now what fun was that... ;-)

Thanks Rick

a much more efficient way