type mismatch on date function when using LCID 1037
Posted on 2004-08-01
I am trying to localize a software written in the US and running as well in Germany and the UK.
The Hebrew Locale (1037) defines date format as dd/mm/yyyy and when writing a simple ASP page as follows, date appears in the same format:
Date is <%=dtDate %>
When using the formatdatetime(date(), vbshortdate) the date is displayed as "þ01/þ08/þ2004" and in debugger mode I see it gets transferred in the URL as yyyy/mm/dd. When runing any date function on it I get tyoe mismatch error.
Any ideas how to resolve this ?
BTW, I'm using client and server on the same machine, with default language Hebrew on Win XP.