Weird as it may sound, when i copy my date column directly from toad data grid to excel, half of the dates get copied with Date format, and half with General format.
When I sort, it treats both the bunches separately. I have tried most of the suggestions I could find. I have tried to set the date format within Toad and the date format in Windows (Region & Locality).
however, it still does the same thing, when I copy and paste it.