Macropod,

Copying/Pasting the superscript example into my document template and
running a merge yields the following:

Friday the 17th of December, 2004 (the 'th' is not superscripted)

Opening the DateCalc 2_41.doc (without running a merge) yields the following:

The following field expresses today in ordinal form, coupled with the day of
the week:
Friday the 17th of December, 2004 ('th' not superscripted, as expected)
or
Friday the 17rd of December, 2004 ('rd' not expected nor is it superscripted)

As a programmer, I thought the unexpected outcome should be reported.
Clearly there is something different with opening the .dot and using the .dot
to create a .doc in a merge.

The code you've provided is of tremendous value. Thank you very, very much
for having provided it and for taking the time to respond to my report. You
have opened a whole new set of possibilities for us.


"macropod" wrote:

Hi UsedBits,

The 'Insert A Date with Text using a Form Field' formula has nothing that
relies on European vs US date formats. So, unless you edited it (eg changing
the formula), it should work correctly regardless of your regional settings.

Cheers


"UsedBits" wrote in message
...
Macropod,

I had to convert the formulas for American date format (MMM/DD/YYYY) to
get
the date arithmetic to display as intended (per original question
regarding
adding 120 days to a merged date). Could it be that the superscripting is
suffering the same fate, i.e., expecting European be receiving American
formatted dates?

At any rate, your work with the code fields is amazing. Thanks, very much
for providing it in a public forum.

Regards,
UsedBits

"macropod" wrote:

Hi UsedBits,

I don't understand how you got "Thursday, the 16rd of December, 2004" -
the
same field returns "Thursday, the 16th of December, 2004" for me, with
superscripting.

Cheers

"UsedBits" wrote in message
...
Charles & MacroPod,

All I can say is "Wow!" Thanks!

I first saw this kind of date arithmetic way back in the early
eighties
when
working on the lowly IBM system/34 RPG-based system. We had a bunch
of
this
stuff for doing date arithmetic, including leap year. However, not
only
did
I not know in Word how to 'parse the dates' as you have shown, I had
completely forgotten about all that stuff.

Oh - there is an error in the WOPR document. It incorrectly displays
the
superscripted date (Insert A Date with Text using a Form Field).
December
16, 2004 displays as "Thursday, the 16rd of December, 2004". The 'rd'
is
not
superscripted.

Again, this is an amazing piece of work. It has opened a whole new
world!

Regards,
UsedBits

"UsedBits" wrote:

I'm trying display a date with 120 days added to it. The date is
merged
into
the document. The following formula {=DateAdd("d",120,{ MERGEFIELD
"ODP_DATE" } ) } simply displays the formula as a text literal with
the
merged date whether or not contained in a 1x1 table.

The document reads something like this:

You have 120 days from {MERGEFIELD ODP_DATE} to return service. The
new
date is {=DateAdd("d",120,{ MERGEFIELD "ODP_DATE" })}.

Hi UsedBits,

Glad to be of help, though I still don't understand what's causing the
problem you're having with the superscripting example in 'Insert A Date with
Text using a Form Field' - I can't replicate it.

Cheers


"UsedBits" wrote in message
...
Macropod,

Copying/Pasting the superscript example into my document template and
running a merge yields the following:

Friday the 17th of December, 2004 (the 'th' is not superscripted)

Opening the DateCalc 2_41.doc (without running a merge) yields the
following:

The following field expresses today in ordinal form, coupled with the day
of
the week:
Friday the 17th of December, 2004 ('th' not superscripted, as expected)
or
Friday the 17rd of December, 2004 ('rd' not expected nor is it
superscripted)

As a programmer, I thought the unexpected outcome should be reported.
Clearly there is something different with opening the .dot and using the
..dot
to create a .doc in a merge.

The code you've provided is of tremendous value. Thank you very, very
much
for having provided it and for taking the time to respond to my report.
You
have opened a whole new set of possibilities for us.


"macropod" wrote:

Hi UsedBits,

The 'Insert A Date with Text using a Form Field' formula has nothing
that
relies on European vs US date formats. So, unless you edited it (eg
changing
the formula), it should work correctly regardless of your regional
settings.

Cheers


"UsedBits" wrote in message
...
Macropod,

I had to convert the formulas for American date format (MMM/DD/YYYY)
to
get
the date arithmetic to display as intended (per original question
regarding
adding 120 days to a merged date). Could it be that the
superscripting is
suffering the same fate, i.e., expecting European be receiving
American
formatted dates?

At any rate, your work with the code fields is amazing. Thanks, very
much
for providing it in a public forum.

Regards,
UsedBits

"macropod" wrote:

Hi UsedBits,

I don't understand how you got "Thursday, the 16rd of December,
2004" -
the
same field returns "Thursday, the 16th of December, 2004" for me,
with
superscripting.

Cheers

"UsedBits" wrote in message
...
Charles & MacroPod,

All I can say is "Wow!" Thanks!

I first saw this kind of date arithmetic way back in the early
eighties
when
working on the lowly IBM system/34 RPG-based system. We had a
bunch
of
this
stuff for doing date arithmetic, including leap year. However,
not
only
did
I not know in Word how to 'parse the dates' as you have shown, I
had
completely forgotten about all that stuff.

Oh - there is an error in the WOPR document. It incorrectly
displays
the
superscripted date (Insert A Date with Text using a Form Field).
December
16, 2004 displays as "Thursday, the 16rd of December, 2004". The
'rd'
is
not
superscripted.

Again, this is an amazing piece of work. It has opened a whole
new
world!

Regards,
UsedBits

"UsedBits" wrote:

I'm trying display a date with 120 days added to it. The date
is
merged
into
the document. The following formula {=DateAdd("d",120,{
MERGEFIELD
"ODP_DATE" } ) } simply displays the formula as a text literal
with
the
merged date whether or not contained in a 1x1 table.

The document reads something like this:

You have 120 days from {MERGEFIELD ODP_DATE} to return service.
The
new
date is {=DateAdd("d",120,{ MERGEFIELD "ODP_DATE" })}.