I've attacthed the document I created along with the macros that were pasted from the samples

Attached Files

Ordinal Test .docm (27.8 KB, 4 views)

See also: https://www.msofficeforums.com/word-...t-ordinal.html

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Greg. Thanks. This works and I created a new document copying your macros and date picker field and it works. But when I try to add a new date picker of my own, it doesn't work. How can I create one that works. Also, when I click on properties for your date picking field I don't get as many options. Why is that?

Greg has been super helpful in displaying the ordinal date in the format
"D of MMMM,YYYY" Now I need to change the ordinal disaplay to "MMMM D" and I'm not sure how to modify the code.


This what I've been using as mod_SpecFormatDates See Attachment

Attached Files

old code.txt (5.5 KB, 5 views)

Roger, I'm not sure I understand what you are trying to do. In the file download, I provided examples for outputting the selected date in both "D of MMMM, YYYY" and "MMMM d, YYYY" do you only want MMMM d?


If so, modify:

Case "BODMDY"
With oRng
.Text = Format(oDate, "MMMM d")
.Collapse wdCollapseEnd
.Start = .End
.InsertAfter fcnOrdinal(Format(oDate, "D"))
.Font.Superscript = True
.Start = .End
'.InsertAfter " " & Format(oDate, "YYYY") (stet out this line)
.Font.Superscript = False
End With

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/

Thanks Greg, Let me look at your examplges again. Also now it will be MMMM d, YYYy

OK Greg. Here's what I don't understand. Do I have to change something to do something to change from EOD to BODMDY?
Thanks,
ROger

FIgured it out. thanks

You've been super helpful in the past. I'm now facing a new and perplexing problem. When I insert a date picker, it works until I save the file. It ceases to function in a saved file. I've tried to save as both a document and template, with and without macro support and the result is the same. One the file is saved, the datepicker ceases to function. Any thoughts?

If the datepicker is being deleted, that suggests you're saving the document in the older .doc format, which doesn't support content controls. Content controls get converted to plain text in such documents.

If it's just that the ordinal function ceases to work, that suggests you're saving the document in the .docx format and that the ordinal function is in an underlying .docm document instead of being in a .dotm template to which your document is attached.

If neither of those is the issue, then, without actually seeing the problem document, it can be difficult for anyone to work out what's going on. Can you attach a document to a post with some representative data (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Paul, I was saving as docm or dotm. Deleting the normal template and recreating it seems to have solved it. What I realized was unusual that if the date picker or other content control didn't function in a saved file, when I opened the enable editing menu and close it full functionality returns, even though I never disabled editing. Strange

Glad you got it sorted.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]