[AccessD] date format

Hello Karen,

the default format for dates in the control panel is Ok.

Thanks

ps. do you have time to look at the structure of the database i send you? I 
have send you ofline two emails, but did not receive an answer.

Pedro Janssen



----- Original Message ----- 
From: "Nicholson, Karen" <cyx5 at cdc.gov>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Monday, November 14, 2005 2:53 PM
Subject: Re: [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
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>