Clive Moss wrote:[url]www.aspfaq.com[/url]> Hello all
> I'm having trouble getting iis to understand the UK format of dates
> ASP off a MS Access database
> I have the following query:
> objRS.Open "Select CheckInitial.ID, CheckInitial.TagNo,
> CheckInitial.TagDate, CheckInitial.PassFail, CheckInitial.IbiD,
> Users.CoName From CheckInitial Inner Join Users on CheckInitial.IbId
> = Users.ID Where (CheckInitial.TagDate Between #" & varFirst & "# And
> #" & varLast & "#) And CheckInitial.IbId = " & ib & " Order by
> TagDate Desc"
> varFirst and varLast are pulled from a form input
> I get wrong results because the input is read as if it is US style
> dates not dd/mm/yy
> I have set the Session.LCID to 2057. I have played around with CDate
> in every combination possible.
> The problem is the same on my local server (set to US settings) and
> the host server (set to UK).
> I appreciate that this type of question must have been asked many
> times but I could not find your faq page on Google
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.