OutputTo and Date Formats

[mikemaki]

I am using the OutputTo method to output a report to Excel. But the dates on the spreadsheet display as Julian, rather than Gregorian. Can I use a template to control the date format?

 

[Guus2005]

Think you have to set the regional settings on this one!

HTH

 

[mikemaki]

Sorry I haven't gotten back 'til now.

My manager agreed with your regional settings solution. But my settings were set correctly. I did solve the problem, though.

On the report (which is not displayed anyway) I place an apostrophe in front of the date. This makes ACCESS think it is a text field and it doesn't try to manipulate the data into the format I didn't know I really wanted. Then I export the report and subreport to a linked spreadsheet. Then I strip the apostrophe out of the field and Excel thinks it's a date. Works like a charm.