We are using SQL Navigator version 7.2.0.3912. When I export the data with date fields into Excel it comes as TEXT format. i.e., if we use the filter on the column in excel, we cannot see the date fields organized as Year > Month > Days in the drop down. I have to use the excel formula DATEVALUE() and convert the text into datevalue number and format it as DD-MMM-YYYY and then apply the filter. Could you please suggest if there is any way to get the date fields into excel without having to do so many fixes in excel. I noticed this issue only in recent versions… may be from 7.1. I was using 6.4 before and did not have this issue.
Thanks for your feedback, this problem have been fixed in 7.3 version(not relaesed), could you install the new 7.3 beta in your PC and use some new features?
It’s been another year, now, and I’m not seeing a fix or workaround in any related thread. My issue for a many versions of SQL Navigator for Oracle still exports dates as text when saving in Excel format. It’s a royal pain to reformat 20-30 date columns every time I create a new spreadsheet. (I dump result sets to Excel daily.) I’m on Win 7 x64, Oracle 12c x64 & SQL Nav 7.3 x64. Thanks!
This was logged as SQLNAV-1916 and it has been fixed in 7.3 GA release. The current 7.4 beta works as well. Please let me know if you still find problem with 7.4 beta.
we have confirm issue that will get string format when you select old date <=01/01/1900, but if select or type the date >01/01/1900, then export excel fomat was date.
Could you pls have try to select the date >01/01/1900?