AspWebSolution Forums » Products » ASP Report Wizard v2 » Problem with date format in Excel export

index | search | no replies | posting guidelines | help

login | register

» »

:: Problem with date format in Excel export :: (12)

Post a New Message | Post a Reply

Apr 5 2006, 3:05 AM

Problem with date format in Excel export

Ed Dwyer

from: MIdlands. UK Hi,

Whilst my dates are showing correctly in European format DD/MM/YY in my reports, when exported in Excel they are being formatted in MM/DD/YY format. I am setting the .DefaultDateFormat = "DD/MM/YY" and even tried setting the field formats to Short Date (Non US) or Medium Dates but still no success. The format of the date fields in the MS SQL databses is small date/time.

I am using the latest version of the program. Is is there something wrong with the export facility or do I need to be doing something additional?

Thanks

Apr 12 2006, 5:46 AM

Re: Problem with date format in Excel export

Ed Dwyer

from: MIdlands. UK Hi, Any news?

Apr 20 2006, 5:44 AM

Re: Problem with date format in Excel export

Ed Dwyer

from: MIdlands. UK Just another gentle prompt - any thoughts yet on this issue?

Apr 20 2006, 11:48 AM

Re: Problem with date format in Excel export

ghost

from: Washington, DC The Locale (Session.LCID) in ASP does not seem to go beyond the web page (This is a known bug from Microsoft). We are still testing for other work arounds. Thanks for your patience.

-------------------------
Ghost

Apr 21 2006, 12:14 AM

Re: Problem with date format in Excel export

Ed Dwyer

from: MIdlands. UK Your assistance is appreciated - many thanks.

Apr 27 2006, 3:44 AM

Re: Problem with date format in Excel export

jmc

since: Feb 24, 2006
from: Gronsveld,Netherlands Hello
Outside US, I think that we are all waiting for a solution or work-around on this problem. It would be nice to give some higher priority to this issue. It is a real pain for these users wanting to upload data into excel.
Thanks in advance.

Apr 28 2006, 7:45 AM

Re: Problem with date format in Excel export

ghost

from: Washington, DC We have come up with a solution which I hope is better than nothing. As of latest version v2.6.15, when exporting files to excel, the dates will be exported using the date format set by the user (in the wizard dialog screen) or in standard format (if nothing has been set) as YYYY-MM-DD which should be recognized by excel as a date field.

Let me know if this helps.

P/S: The export process might be a little slower because we have to validate the date format first before exporting.

thanx for your patience!

-------------------------
Ghost

Apr 28 2006, 7:56 AM

Re: Problem with date format in Excel export

jmc

since: Feb 24, 2006
from: Gronsveld,Netherlands Great!!
Where can we download this new version?
I will be happy to try it. Is it GA or still beta?

Apr 28 2006, 8:02 AM

Re: Problem with date format in Excel export

ghost

from: Washington, DC Actually, it is currently available for download at our download center .

thanx!

-------------------------
Ghost

Apr 28 2006, 9:10 AM

Re: Problem with date format in Excel export

Ed Dwyer

from: MIdlands. UK Many thanks for the solution - it sounds as if will do the trick for us. I will implement the new version early next week and advise you on progress.

May 25 2006, 12:13 AM

Re: Problem with date format in Excel export

Ed Dwyer

from: MIdlands. UK Hi,

Sorry for the delay in replying. I have downloaded and tested the new version of the program and it works to some correctly to an extent. It now outputs the date in DD/MM/YYYY format and not YYYY-MM-DD format. The latter format would be most helpful with sorts etc. Is this something you can fix easily? You are right in that it does take a little longer to export to Excel but nothing significant. I also notice that you have changed the default Excel spreadsheet name to ASPWebSolution_Report.XLS. Is it possible to retain the orginal Report.XLS name from previous releases - this would help me too?

Thanks for the effort you have put it.
Regards.

Jun 5 2006, 12:07 PM

Re: Problem with date format in Excel export

Ed Dwyer

from: MIdlands. UK Any ideas yet on these?

Regards,

ED

Pages: (1) [1]