i am exporting data from two date fields along with other texr data to ms word to print labels. the display date format in sesame is the way i want it on the labels.
mm/dd/yyyy.
but when i merge the data the format that shows up in word is backwards. yyyy/dd/mm.
i am also creating macros to do this for me.
is there a way to get the correct date format in word?
Thanks
Larry

Hi Larry.

Sesame stores all dates internally in the format yyyy/mm/dd.
Numbers are stored internally with six decimal places and exported numbers will be in a format containing 6 decimals.

That is what will be exported to all other programs,not just to Word.
=====================================
In Word, you can do the following:
Go the the Merge Field.
Right click on the merge field, and select Toggle Field Codes
You will see something like this: {MERGEFIELD "DateField"}
Edit that and insert the following:  \@MM/dd/yyyy at the end, after the quotes, before the }, so you end up with this:
{MERGEFIELD "DateField" \@MM/dd/yyyy}

This will end up with a date format like 10/09/2005

See Word Help for other formats. 
Search Help for "Format merged data" without the quotes

Some other examples:
\@ "MMMM d, yyyy will give you October 9, 2005
\# ###### will give 6 digit number, no punctuation, no decimals.........123456
\# ##.0 will give 2 digit number, one decimal place, no leading zeroes............2.3
\# $###.00 will give currency with leading $, two decimals..........$123.45