Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange date formatting
Message
From
09/09/2008 20:02:24
 
 
To
09/09/2008 19:31:51
Alan Harris-Reid
Baseline Data Services
Devon, United Kingdom
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Vista
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01346235
Message ID:
01346236
Views:
21
Hi Alan,

Try selecting entire column prior to formatting
oWorkSheet.Columns(5).Select
oXl.Selection.NumberFormat='dd/mm/yy'
>Hi,
>
>I am having problems outputting certain dates from a cursor to an Excel spreadsheet using OLE automation. The date format setting is SET DATE ITALIAN (ie. dd-mm-yyyy). When the day is greater than 12, the date is correctly output (eg. 24-06-2008) but when the day is less than or equal to 12, the date is output is in mm/dd/yyyy format, ie. 7th January 2005 appears as 01/07/2005 instead of the expected 07-01-2005 (with / instead of - and the days/months reversed). All dates display correctly when I browse the cursor.
>
>The automation code that loads the cell is as follows...
> oWorkSheet.Cells(lnRow,5).value = MyDateField
>
>I have tried the following, all without success...
> SET DATE BRITISH
> SET DATE DMY
> oWorkSheet.Columns(5).NumberFormat = 'dd/mm/yy'
> oWorkSheet.Cells(lnRow,5).value = DTOC(MyDateField)
> oWorkSheet.Cells(lnRow,5).value = TRANSFORM(MyDateField,'@D')
>
>Can anyone tell me how to get all dates into the correct format? Why is Excel trying to convert dates to American format? Any help would be appreciated.
>
>TIA
>Alan
Previous
Reply
Map
View

Click here to load this message in the networking platform