In my Access2003 I've store a data as 17-Nov 2003.<BR><BR>When in asp I do <% = rs("Publised_date") %> it's displayed as<BR>mm/dd/yyyy. How can I display the date in dd/mm/yyyy format ?
First, do it manually:<BR>[code language="VBScript"]Response.Write Day(rs("Published_date")) & "/" & Month(rs("Published_date")) & "/" & Year(rs("Published_date"))[/code]<BR><BR>Or, you can change your Session.LCID to the appropriate value. <BR><BR>I believe there is a FAQ on this subject on AspFaqs.com. It might be helpful for you to read that.
with my Global.asa file. <BR><BR>When I added Session.LCID = 1044 to SUB Session_OnStart in my Global.asa there was no change to my date format. However when I manually added Session.LCID to a asp page then the date format works fine. It would seem that my asp file does not readuse the Global.asa file. I also have an application("footer") = "..." that I've implemented onto my page and it doesnt work either.<BR><BR>What can cause my Global.asa not to work ? <BR><BR>The file is located in the root of my webarea.<BR><BR>
The thing is though, the global.asa file worked great on my test webserver but once I moved the files over to the main server the Global.asa file did not work.<BR><BR>The file looks like this :<BR><BR><SCRIPT runat="Server" LANGUAGE="VBScript"><BR>SUB application_onstart<BR> Application("ConnectionString") = "DSN=pubs"<BR> Application("VisitorCount") = 0 <BR> Application("StartTime") = Now<BR> Application("Footer") = "Sist oppdatert 13 November 2003"<BR>END SUB<BR><BR>SUB Application_OnEnd<BR>END SUB<BR><BR>SUB Session_OnStart<BR> Session.Timeout = 10<BR> Session.LCID = 1044<BR> Application.Lock<BR> Application("VisitorCount") = Application("VisitorCount") + 1<BR> Application.UnLock<BR> <BR>END SUB<BR><BR>SUB Session_OnEnd<BR>END SUB<BR></script>
Maybe you have more than one virtual dir on the main server? If so, you have to have a Global.ASA for each one. The one in the main root would only apply to apps in that same root.<BR><BR>Is this main server a shared host? On some ISP? If so, ask the ISP if you need to do something special.<BR><BR>