Date format error in VBA

C

ChrisCPS

I am using Delphi to create Excel spreadsheet. Under OfficeXP using UK
locale(shortdate format dd/mm/yyyy) dates with day <=12 are being formatted
as mm/dd/yyyy, dates with dd >12 are formatted in right order.
The same application running under WinXP but with Office97-SR2 all dates
format ok.
Is there a bug in OfficeXP (or versions > 97)??
I see Microsoft article 213514 describes the symptoms exactly - is there a
fix for this?? or a workaround? I have tried different display formats (e.g.
longdateformat) in my Delphi tables, but the MM/dd reversal still occurs.
(Using D6, TscExcelExport)
Thanks
Chris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Forcing a date entry format of dd/mm/yyyy 1
International Date formatting 6
date format convert 3
displaying dates in UK format 10
Date formatting 1
Formatting date gives bad results in query 2
SAVE AS CSV, KEEP DATE FORMAT 2
Date Formats for Cells Do not match System Date Formats 5

Top