>hi all,
>
>when i export (through OLE) a vfp6 cursor with data to an MS Excel spreadsheet file, some dates like 5th Mar, 2008 get displayed as 03-May-2008 (the date and month get interchanged always)
>
>why does this happen ? and, how can i prevent this from happenning ?
>
>with sincere thanks in advance.
And what happens when the day is > 12?
It looks as if different date formats get mixed-up. Take a look at the command SET DATE - it may help to change it before exporting.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)