In MS Word 2000, I've added a text form field. Then, I gave it "Date format" setting of MM/DD/YY. Now, based on the Date that the user enters, I would like to create a second field that automatically populates the day of the week based on that date (Mo, Tu, We, etc). Any ideas?
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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Office 2000 - In forms/date type field - show day of week possible? 1
- Thread starter ziggs
- Start date
-
1
- #2
I don't use Word text form fields, but if you change the date format from MM/DD/YY to a custom one of dddd dd-mm-yy
do you not get Thursday 01/07/10 ?(dddd mm-dd-yy if you prefer)
That's how Excel works so presume(maybe wrongly) that this would work. This means all date inc day is in one field which may be not what you want. If you realy need date in a sep field , try format of dddd.
do you not get Thursday 01/07/10 ?(dddd mm-dd-yy if you prefer)
That's how Excel works so presume(maybe wrongly) that this would work. This means all date inc day is in one field which may be not what you want. If you realy need date in a sep field , try format of dddd.
- Thread starter
- #3
So, MM/DD/YY DDD worked and gives me a three letter abbreviation. I would prefer a two letter day abbreviation if possible.
Also, can the following be solved. The three fields on a report that I can't change is:
Date Time Day
6/1/10 0641 Tue
Based on your new formula, it now looks like:
Date Time Day
6/1/10 Tue 0641
Is there anyway I can have the "Day" text form field populate the Tue based on the date of 6/1/10 being entered in the "Date" text form field?
Thanks
Also, can the following be solved. The three fields on a report that I can't change is:
Date Time Day
6/1/10 0641 Tue
Based on your new formula, it now looks like:
Date Time Day
6/1/10 Tue 0641
Is there anyway I can have the "Day" text form field populate the Tue based on the date of 6/1/10 being entered in the "Date" text form field?
Thanks
So, DDD worked and gives me a three letter abbreviation. I would prefer a two letter day abbreviation if possible. -
I don't think there is one
so go back to how it was,
date(MM/DD/YY) & time in respective columns but this time, copy the date field to the day column but change that copied field's format to DDD to get Tue
That's the best offer(there are ways in Excel and CR(to ) but really not worth the hassle in Word when 3 letter day names are OK really
I don't think there is one
so go back to how it was,
date(MM/DD/YY) & time in respective columns but this time, copy the date field to the day column but change that copied field's format to DDD to get Tue
That's the best offer(there are ways in Excel and CR(to ) but really not worth the hassle in Word when 3 letter day names are OK really
- Thread starter
- #5
I can stick with the three letter abbreviation. I tried the copy and paste, but I didn't get it to work as expected. I unprotected the form. Created MM/DD/YY for one field, copied that field and pasted it to another field. After changing the properties of the 2nd field, I then protected the form again.
When I entered a date into field one and tabbed to the next field, the 2nd day field did not autopopulate with the day based on the date that I entered into field one. Is there a special way to copy field one?
When I entered a date into field one and tabbed to the next field, the 2nd day field did not autopopulate with the day based on the date that I entered into field one. Is there a special way to copy field one?
- Status
