By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,950 Members | 989 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,950 IT Pros & Developers. It's quick & easy.

How to Return a day?

P: n/a
kai
Hi,
I am looking for a function returning day like Day([orderDay])=Monday but
it only return1 "1". Is it possible?

Thanks

Kai
Oct 17 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
kai wrote:
Hi,
I am looking for a function returning day like
Day([orderDay])=Monday but it only return1 "1". Is it possible?
Format([orderDay], "dddd")

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Oct 17 '06 #2

P: n/a
kai wrote:
Hi,
I am looking for a function returning day like Day([orderDay])=Monday but
it only return1 "1". Is it possible?
It might be worthwhile for you to learn how to explore the VB object
browser.

Open a standard module. Press <F2>.

The object browser should open. In the search box (beside the
binoculars) enter "day" without the quotation marks. Click on the
binoculars.

You will find properties, methods and functions whose names include
"day". From these you can pick:

WeekdayName
and
Weekday

With a little experimentation you can come up with something like:
Debug.print WeekdayName(Weekday(Date))
You will find that this shows "Tuesday" (or equivalent) in the
Immediate Window.
>From this you will be able to devise.
WeekdayName(Weekday([OrderDay]))

And soon you will be able to help answer questions of beginners and MLH
....

(I have used Access 2003 to check the contents of this post.)

Oct 17 '06 #3

P: n/a
kai
Thanks!!!

Kai
"Rick Brandt" <ri*********@hotmail.comwrote in message
news:pT*****************@newssvr21.news.prodigy.co m...
kai wrote:
>Hi,
I am looking for a function returning day like
Day([orderDay])=Monday but it only return1 "1". Is it possible?

Format([orderDay], "dddd")

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Oct 18 '06 #4

P: n/a
kai
Thanks a lot!

kai
"Lyle Fairfield" <ly***********@aim.comwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...
kai wrote:
>Hi,
I am looking for a function returning day like Day([orderDay])=Monday
but
it only return1 "1". Is it possible?

It might be worthwhile for you to learn how to explore the VB object
browser.

Open a standard module. Press <F2>.

The object browser should open. In the search box (beside the
binoculars) enter "day" without the quotation marks. Click on the
binoculars.

You will find properties, methods and functions whose names include
"day". From these you can pick:

WeekdayName
and
Weekday

With a little experimentation you can come up with something like:
Debug.print WeekdayName(Weekday(Date))
You will find that this shows "Tuesday" (or equivalent) in the
Immediate Window.
>>From this you will be able to devise.

WeekdayName(Weekday([OrderDay]))

And soon you will be able to help answer questions of beginners and MLH
...

(I have used Access 2003 to check the contents of this post.)

Oct 18 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.