J
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
access 97 but help can't find veenlr3.hlp
Thanks,
Jason
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
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?
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?
R
Rick Brandt
Jason said: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")
P
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
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
J
Jason
a much more efficient wayNow what fun was that... ;-)
Thanks Rick