[AccessD] date format

Did you check your control panel to see the default format for dates?
That has caused me problems in the past.  Just a thought. 


Karen S. Nicholson
Programmer Analyst
EG&G Technical Services, Inc.
Pittsburgh, PA
Phone: 412-386-6649
Email: cyx5 at cdc.gov


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of pedro at plex.nl
Sent: Monday, November 14, 2005 9:41 AM
To: AccessD at databaseadvisors.com
Subject: [AccessD] date format

Hello Group,

i have to date-fields in a table, both with the same preferences and
both display there data in format dd-MM-yyyy.
When i use mailmerge with word, with the prps.item i get a different
result, MM\dd\yyyy and dd\MM\yyyy. In this mailmerge also the function
TodayDate is used, this gives dd-MM-yyyy. I now have changed the
different format in the worddocument, to the same output, by using:
{DOCPROPERTY "GebDat" \@ "dd-MM-yyyy" \*MERGEFORMAT} {DOCPROPERTY
"DDatum" \@ "MM-dd-yyyy" \*MERGEFORMAT}

How is possible that two the same fields in access give different
results? Is there a hidden format in the date fields?

When the Date-seperator in the country-preferences is choosen as "-",
how can access gives "\" as seperator and why not in TodayDate?

TIA

Pedro Janssen
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com