[AccessD] date format

pedro at plex.nl pedro at plex.nl
Mon Nov 14 14:41:09 CST 2005


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



More information about the AccessD mailing list