software

Using an excel worksheet of data which includes dates - dates 'formated'
using e.g. quot;Wednseday, April 5 2006quot; are actually displayed as quot;Thursday,
April 5 2006quot;. When choosing fields to include in the merge the date is
already corrupted as above. I tried various dates and the same issues occurs.

Are you sure it's Thursday, April 5 2006, or is it really Thursday,
April 4, 2002?

The former makes no sense.

The second one could come from a conversion from the 1904 date system to
the 1900 date system. If you're copying data from a workbook in the 1904
system to one in the 1900 system, that would occur as well.In article gt;,
toto gt; wrote:

gt; Using an excel worksheet of data which includes dates - dates 'formated'
gt; using e.g. quot;Wednseday, April 5 2006quot; are actually displayed as quot;Thursday,
gt; April 5 2006quot;. When choosing fields to include in the merge the date is
gt; already corrupted as above. I tried various dates and the same issues occurs.

It is definitely quot;Thursday, April 5 2006quot;, i.e. 2006. Though as I said
before, the original formated cell is correct, quot;Wednesdat, April 5 2006quot;.

quot;JE McGimpseyquot; wrote:

gt; Are you sure it's Thursday, April 5 2006, or is it really Thursday,
gt; April 4, 2002?
gt;
gt; The former makes no sense.
gt;
gt; The second one could come from a conversion from the 1904 date system to
gt; the 1900 date system. If you're copying data from a workbook in the 1904
gt; system to one in the 1900 system, that would occur as well.
gt;
gt;
gt; In article gt;,
gt; toto gt; wrote:
gt;
gt; gt; Using an excel worksheet of data which includes dates - dates 'formated'
gt; gt; using e.g. quot;Wednseday, April 5 2006quot; are actually displayed as quot;Thursday,
gt; gt; April 5 2006quot;. When choosing fields to include in the merge the date is
gt; gt; already corrupted as above. I tried various dates and the same issues occurs.
gt;

Have fixed the problem in the interim by amending the 'toggle field code' as
follows: {mergefiled quot;event_datequot; \@ quot;dddd, MMMM d, yyyyquot;}quot;totoquot; wrote:

gt; It is definitely quot;Thursday, April 5 2006quot;, i.e. 2006. Though as I said
gt; before, the original formated cell is correct, quot;Wednesdat, April 5 2006quot;.
gt;
gt; quot;JE McGimpseyquot; wrote:
gt;
gt; gt; Are you sure it's Thursday, April 5 2006, or is it really Thursday,
gt; gt; April 4, 2002?
gt; gt;
gt; gt; The former makes no sense.
gt; gt;
gt; gt; The second one could come from a conversion from the 1904 date system to
gt; gt; the 1900 date system. If you're copying data from a workbook in the 1904
gt; gt; system to one in the 1900 system, that would occur as well.
gt; gt;
gt; gt;
gt; gt; In article gt;,
gt; gt; toto gt; wrote:
gt; gt;
gt; gt; gt; Using an excel worksheet of data which includes dates - dates 'formated'
gt; gt; gt; using e.g. quot;Wednseday, April 5 2006quot; are actually displayed as quot;Thursday,
gt; gt; gt; April 5 2006quot;. When choosing fields to include in the merge the date is
gt; gt; gt; already corrupted as above. I tried various dates and the same issues occurs.
gt; gt;

What was it before?

In article gt;,
toto gt; wrote:

gt; Have fixed the problem in the interim by amending the 'toggle field code' as
gt; follows: {mergefiled quot;event_datequot; \@ quot;dddd, MMMM d, yyyyquot;}