date format mm/dd/yyyy or dd/mm/yyyy

[Alistair]

it's the idiot with his query strings again...."yippeee" I hear aaron shout

this time the problem is with a date format query

I have a query string thus

strSQL = "SELECT * FROM users where creation_date >= #" & strthisweekstart &
"# AND creation_date <= #" & strthisweekend & "#"

strthisweek start is dateadd("d",-7,date) and strthisweekend is date(). The
idea is it shows the records that were added in the last week

so a week ago a response.write of this gave

SELECT * FROM users where creation_date >= #31/12/2004# AND creation_date <=
#7/01/2004#

and I thought everything was fine as I got the correct number of records

today I check again and I get the result of zero records, I know this is
wrong..so another response.write and I get

SELECT * FROM users where creation_date >= #07/01/2004# AND creation_date <=
#14/01/2004#

which *appears* right only it seems that the first date is in the format
mm/dd/yyy and the second is dd/mm/yyyy

I've checked this by creating a record with the creation date of 14/06/2004,
the query then returns correctly, 1 record

so, the pages are interpreting anything that CAN be in the format of
mm/dd/yyyy as such and anything that can't be this format is interpreted as
dd/mm/yyyy

where do I tell the pages which date format to use for ALL dates?

bearing in mind I'm in the UK and my windows settings are in UK format
(dd/mm/yyyy), which I thought would automatically set the correct format.

thanks

[Vilmar Brazão de Oliveira]

hi,
could you use only yyyy/mm/dd ??
if this is possible you have always invert you dates, else
you have treat each case before make a search.
bye

--

««««««««»»»»»»»»»»»»»»
Vlmar Brazão de Oliveira
Desenvolvimento Web
HI-TEC
"Alistair" <news@*remove*alistairb.co.uk> escreveu na mensagem
news:10************@corp.supernews.com...

it's the idiot with his query strings again...."yippeee" I hear aaron shout
this time the problem is with a date format query

I have a query string thus

strSQL = "SELECT * FROM users where creation_date >= #" & strthisweekstart & "# AND creation_date <= #" & strthisweekend & "#"

strthisweek start is dateadd("d",-7,date) and strthisweekend is date(). The idea is it shows the records that were added in the last week

so a week ago a response.write of this gave

SELECT * FROM users where creation_date >= #31/12/2004# AND creation_date <= #7/01/2004#

and I thought everything was fine as I got the correct number of records

today I check again and I get the result of zero records, I know this is
wrong..so another response.write and I get

SELECT * FROM users where creation_date >= #07/01/2004# AND creation_date <= #14/01/2004#

which *appears* right only it seems that the first date is in the format
mm/dd/yyy and the second is dd/mm/yyyy

I've checked this by creating a record with the creation date of 14/06/2004, the query then returns correctly, 1 record

so, the pages are interpreting anything that CAN be in the format of
mm/dd/yyyy as such and anything that can't be this format is interpreted as dd/mm/yyyy

where do I tell the pages which date format to use for ALL dates?

bearing in mind I'm in the UK and my windows settings are in UK format
(dd/mm/yyyy), which I thought would automatically set the correct format.

thanks

[Alistair]

I have seen this but I don't know how to use it. I would ahave to change 4
fields in a DB containing 22,000 entries too. I think

anyway...if I do a response.write date() I get the correct format....so why
would it be different for other times?

"Vilmar Brazão de Oliveira" <su*****@hitecnet.com.br> wrote in message
news:uB**************@TK2MSFTNGP10.phx.gbl...

hi,
could you use only yyyy/mm/dd ??
if this is possible you have always invert you dates, else
you have treat each case before make a search.
bye

--

««««««««»»»»»»»»»»»»»»
Vlmar Brazão de Oliveira
Desenvolvimento Web
HI-TEC
"Alistair" <news@*remove*alistairb.co.uk> escreveu na mensagem
news:10************@corp.supernews.com...

it's the idiot with his query strings again...."yippeee" I hear aaron shout

this time the problem is with a date format query

I have a query string thus

strSQL = "SELECT * FROM users where creation_date >= #" & strthisweekstart &

"# AND creation_date <= #" & strthisweekend & "#"

strthisweek start is dateadd("d",-7,date) and strthisweekend is date(). The

idea is it shows the records that were added in the last week

so a week ago a response.write of this gave

SELECT * FROM users where creation_date >= #31/12/2004# AND

creation_date <=

#7/01/2004#

and I thought everything was fine as I got the correct number of records

today I check again and I get the result of zero records, I know this is
wrong..so another response.write and I get

SELECT * FROM users where creation_date >= #07/01/2004# AND

creation_date <=

#14/01/2004#

which *appears* right only it seems that the first date is in the format
mm/dd/yyy and the second is dd/mm/yyyy

I've checked this by creating a record with the creation date of

14/06/2004,

the query then returns correctly, 1 record

so, the pages are interpreting anything that CAN be in the format of
mm/dd/yyyy as such and anything that can't be this format is interpreted

as

dd/mm/yyyy

where do I tell the pages which date format to use for ALL dates?

bearing in mind I'm in the UK and my windows settings are in UK format
(dd/mm/yyyy), which I thought would automatically set the correct

format.
thanks

[Vilmar Brazão de Oliveira]

HI,
I don't know exactly, but have you tried anything like this:
'07/01/2004' instead #07/01/2004#
??
bye

--

««««««««»»»»»»»»»»»»»»
Vlmar Brazão de Oliveira
Desenvolvimento Web
HI-TEC
"Alistair" <news@*remove*alistairb.co.uk> escreveu na mensagem
news:10*************@corp.supernews.com...

I have seen this but I don't know how to use it. I would ahave to change 4
fields in a DB containing 22,000 entries too. I think

anyway...if I do a response.write date() I get the correct format....so why would it be different for other times?

"Vilmar Brazão de Oliveira" <su*****@hitecnet.com.br> wrote in message
news:uB**************@TK2MSFTNGP10.phx.gbl...

hi,
could you use only yyyy/mm/dd ??
if this is possible you have always invert you dates, else
you have treat each case before make a search.
bye

--

««««««««»»»»»»»»»»»»»»
Vlmar Brazão de Oliveira
Desenvolvimento Web
HI-TEC
"Alistair" <news@*remove*alistairb.co.uk> escreveu na mensagem
news:10************@corp.supernews.com...

it's the idiot with his query strings again...."yippeee" I hear aaron

shout

this time the problem is with a date format query

I have a query string thus

strSQL = "SELECT * FROM users where creation_date >= #" & strthisweekstart

&

"# AND creation_date <= #" & strthisweekend & "#"

strthisweek start is dateadd("d",-7,date) and strthisweekend is date().

The

idea is it shows the records that were added in the last week

so a week ago a response.write of this gave

SELECT * FROM users where creation_date >= #31/12/2004# AND creation_date

<=

#7/01/2004#

and I thought everything was fine as I got the correct number of

records
today I check again and I get the result of zero records, I know this is wrong..so another response.write and I get

SELECT * FROM users where creation_date >= #07/01/2004# AND

creation_date

<=

#14/01/2004#

which *appears* right only it seems that the first date is in the format mm/dd/yyy and the second is dd/mm/yyyy

I've checked this by creating a record with the creation date of

14/06/2004,

the query then returns correctly, 1 record

so, the pages are interpreting anything that CAN be in the format of
mm/dd/yyyy as such and anything that can't be this format is

interpreted as

dd/mm/yyyy

where do I tell the pages which date format to use for ALL dates?

bearing in mind I'm in the UK and my windows settings are in UK format
(dd/mm/yyyy), which I thought would automatically set the correct

format.
thanks