Date format in Export Dataset | Excel Instance is "3 letters" or "fully spelled out" only (185689)

Date format in Export Dataset | Excel Instance is "3 letters" or "fully spelled out" only

When wanting to export a dataset to excel instance, the only options for dates are to export them in "3 letters" or "fully spelled out".

Would it be possible to get the format as DD/MM/YYYY.?

RESOLUTION

The only way to get such format is to export in Excel File, not instance.

If you want this is considered please go to Idea Pond  (https://www.toadworld.com/products/toad-for-oracle/i ) and enter your request there.
Idea Pond is a site where you can tell the development team what you want, and tell us how important it is by submitting, voting, and commenting on ideas. Just sign in and submit your idea there.

When Toad sends dates to excel, it can send them as dates or strings. We have had reports in the past of Excel getting Days and Months mixed up when we used to send as dates, so now we send as strings. Ideally, Excel should recognize that the string is a date, convert it, and then you should be able to format it how you like. Toad 10 sent the string as DD-MMM-YYYY, which worked great except for Slovakian. So then we changed to MMMM (which is month fully spelled out). Now we have the option to export month as 3 letter month or fully spelled out. One or the other will hopefully work for everyone, and then the actual date format can be set in Excel.