Dates again

[Clive Moss]

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

TIA

Clive

[Bob Barrows]

Clive Moss wrote:

> 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
>
> TIA
>
> Clive

[url]www.aspfaq.com[/url]

in particular:
[url]http://www.aspfaq.com/show.asp?id=2260[/url]
and
[url]http://www.aspfaq.com/show.asp?id=2040[/url]

HTH,
Bob Barrows
--
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.

[Clive Moss]

"<snip>

> > TIA
> >
> > Clive

>
> [url]www.aspfaq.com[/url]
>
> in particular:
> [url]http://www.aspfaq.com/show.asp?id=2260[/url]
> and
> [url]http://www.aspfaq.com/show.asp?id=2040[/url]
>
> HTH,
> Bob Barrows
> --

Thanks, Bob ,but that site is down at present - Probably why I was getting
nowhere trying to get to it. I'll try later

Thanks again
Clive

[Bob Barrows]

Clive Moss wrote:

> "<snip>

>>> TIA
>>>
>>> Clive

>>
>> [url]www.aspfaq.com[/url]
>>
>> in particular:
>> [url]http://www.aspfaq.com/show.asp?id=2260[/url]
>> and
>> [url]http://www.aspfaq.com/show.asp?id=2040[/url]
>>
>> HTH,
>> Bob Barrows
>> --

> Thanks, Bob ,but that site is down at present - Probably why I was
> getting nowhere trying to get to it. I'll try later
>
> Thanks again
> Clive

Really? It's working fine for me ...
--
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.

[Brynn]

'// To US to UK / UK to US
Function dateSwitch(yourDate)
Dim dateArray: dateArray=Split(yourDate, "/")
dateSwitch = dateAray(1) & "/" & dateArray(0) & "/" &
dateArray(2)
End Function



On Tue, 13 Jan 2004 19:36:54 GMT, "Clive Moss"
<clive@REMOVEinstant-image.co.uk> wrote:

>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
>
>TIA
>
>Clive
>
>

I participate in the group to help give examples of code. I do not guarantee the effects of any code posted. Test all code before use!

Brynn
[url]www.coolpier.com[/url]