The date format appears to be set to dd/mm/yy because when I export to Excel, that is how it shows up as text. Where do I go to make sure it is set as mm/dd/yy? The report displays it fine as mm/dd/yy, it just happens when I send it to Excel, it appears.
Thanks,
Hans
I am pretty sure this is something in FoxFire! I created another data item from another table but using the same function (CTOD) and that field exported correctly to Excel on the same run that produced the 05-Jul-09 text entries. Doing more research for this is interesting. If one field is wrongly formatted but the field next to it is fine, using the same definition, just a different table, there got to be some setting somewhere defining it differently.
And part of the answer is ....
Define the data item as characters instead of as date. It is a CTOD(STRTRAN(....)) function result. Defining as character auto adds a PADR() around the whole thing. Result is that when send to Excel a text value in the right format arrives in Excel which can then be easily converted into a real date value using the text-to-column feature of Excel and then apply whatever formatting is wanted. A macro will quickly do something like that.
I think I can live with this until knowledge increases.