Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Day of Week in Textbox 1

Status
Not open for further replies.

Lambro

Programmer
Aug 22, 2001
258
US
I have two textboxes on my form. One is Date and the other is Day. The date default value is set to =Date()

How to I get the day of the week in the Day Textbox?

The textbox should say Tuesday for Today and Wednesday for tomorrow.... etc...

Thanks
 
One way would be to use the WeekDayName function.


Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein
 
Set the controsource to:

=Format(Date(), "dddd")

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com
 
Worked Perfect mstrmage1768
Thanks
 
One other question with the day of the week.

In my textbox I have a date. It's formated like this: 12/9/2003

My question is, based on the date in this textbox, can I have another textbox which tells me what day of the week it is based off of the date?

Let's say the date in the textbox is 12/01/2003 then the other textbox would display Monday. Is this possible?
Thanks
 
sure...just as above....control source of field to display day:

=Format([fieldname], "dddd")

take a look at the help file for the format function and you can find a bunch of other options also that you may need at some point in the future.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top