IS string date greater than or equal to a SQL server datetime record?

[Hebar Tiltwobler]

I need to figure out if the current date (passed in as a string) is equal
to or greater then a field in my database in the format of- M/D/YYYY AND if
the date is less then another field in my database.


"... WHERE '" & cdate(request("date")) & "' >= CONVERT(varchar,
(datePart(M,appointmentStart)/datePart(D,appointmentStart)/datePart(YYYY,app
ointmentStart)), 103)) AND "&_
"'" & cdate(request("date")) & "' <= (CONVERT(varchar,
(datePart(M,appointmentEnd)/datePart(D,appointmentEnd)/datePart(YYYY,appoint
mentEnd)), 103)) "


Anyone know why my SQL statement above is not working correctly?

PS- I've always wondered why it less thEn instead of less thAn ..? Doesn't
thAn make more sense?


TIA

[Ray at]

"Hebar Tiltwobler" <ready@justfooledyou-notemail.com> wrote in message
news:%23juETYlmDHA.2140@TK2MSFTNGP09.phx.gbl...

>
> PS- I've always wondered why it less thEn instead of less thAn ..? Doesn't
> thAn make more sense?

Where are you seeing less thEn? I can see myself saying that in
conversation. "We can each take 50%. If you want less, then give me more."

Ray at work

[Bob Barrows]

Hebar Tiltwobler wrote:

> I need to figure out if the current date (passed in as a string) is
> equal to or greater then a field in my database in the format of-
> M/D/YYYY AND if the date is less then another field in my database.

Dates are not stored with any format. It is up to the client application to
apply formatting. I suspect your database is SQL Server (why are you making
us guess? :-) ), so if you look up Using Date And Time Data in SQL Books
Online, you will find your answer.

> Anyone know why my SQL statement above is not working correctly?
>
> PS- I've always wondered why it less thEn instead of less thAn ..?
> Doesn't thAn make more sense?
>

I always say/write "less than". I don't know why you think "less then" is
the accepted form.

HTH,
Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Hebar Tiltwobler]

"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:%23hb2malmDHA.3612@TK2MSFTNGP11.phx.gbl...

>
> "Hebar Tiltwobler" <ready@justfooledyou-notemail.com> wrote in message
> news:%23juETYlmDHA.2140@TK2MSFTNGP09.phx.gbl...
>

> >
> > PS- I've always wondered why it less thEn instead of less thAn ..?

Doesn't

> > thAn make more sense?

>
> Where are you seeing less thEn? I can see myself saying that in
> conversation. "We can each take 50%. If you want less, then give me

more."

>
> Ray at work
>
>

Whoops.. was thinking of VBscript.. > then..

I'm wondering why it is not less than instead of then. Isn't "than"
comparitive and "then" a reference to time?

[Hebar Tiltwobler]

"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
news:%23gbRhdlmDHA.2080@TK2MSFTNGP10.phx.gbl...

> Hebar Tiltwobler wrote:

> > I need to figure out if the current date (passed in as a string) is
> > equal to or greater then a field in my database in the format of-
> > M/D/YYYY AND if the date is less then another field in my database.

>
> Dates are not stored with any format. It is up to the client application

to

> apply formatting. I suspect your database is SQL Server (why are you

making

> us guess? :-) ), so if you look up Using Date And Time Data in SQL Books
> Online, you will find your answer.
>

> > Anyone know why my SQL statement above is not working correctly?
> >
> > PS- I've always wondered why it less thEn instead of less thAn ..?
> > Doesn't thAn make more sense?
> >

> I always say/write "less than". I don't know why you think "less then" is
> the accepted form.
>
> HTH,
> Bob Barrows
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>

> Dates are not stored with any format. It is up to the client application

to

> apply formatting.

Correct

>I suspect your database is SQL Server (why are you making
> us guess? :-) ),

Subject line says SQL Server

>so if you look up Using Date And Time Data in SQL Books
> Online, you will find your answer.

Thank you.

[Bob Lehmann]

Less than is correct. Did you hear "then" or see "then"? Maybe you ran into
a regional accent.

Gotta go now, the cah's erl needs to be changed.

Bob Lehmann

"Hebar Tiltwobler" <ready@justfooledyou-notemail.com> wrote in message
news:uo9dTrlmDHA.2964@tk2msftngp13.phx.gbl...

>
> "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
> news:%23hb2malmDHA.3612@TK2MSFTNGP11.phx.gbl...

> >
> > "Hebar Tiltwobler" <ready@justfooledyou-notemail.com> wrote in message
> > news:%23juETYlmDHA.2140@TK2MSFTNGP09.phx.gbl...
> >

> > >
> > > PS- I've always wondered why it less thEn instead of less thAn ..?

> Doesn't

> > > thAn make more sense?

> >
> > Where are you seeing less thEn? I can see myself saying that in
> > conversation. "We can each take 50%. If you want less, then give me

> more."

> >
> > Ray at work
> >
> >

>
> Whoops.. was thinking of VBscript.. > then..
>
> I'm wondering why it is not less than instead of then. Isn't "than"
> comparitive and "then" a reference to time?
>
>
>

[Ray at]

"Hebar Tiltwobler" <ready@justfooledyou-notemail.com> wrote in message
news:uo9dTrlmDHA.2964@tk2msftngp13.phx.gbl...

>

> > Where are you seeing less thEn? I can see myself saying that in
> > conversation. "We can each take 50%. If you want less, then give me

> more."

> >
> > Ray at work
> >
> >

>
> Whoops.. was thinking of VBscript.. > then..
>
> I'm wondering why it is not less than instead of then. Isn't "than"
> comparitive and "then" a reference to time?
>

[url]www.dictionary.com[/url]
just kidding

If 5 is greater than 4 then do this

That's how VBS is, although I wouldn't be surprised if things were messed up
grammatically from time to time. I don't know too many programmers who are
expert grammarians. I try though! I don't use "a lot" or say things like,
"If someone has a cat, they are cool." Who's they? It's he, damn it! And
enough with all that "he or she" or "s/he" nonsense!

Ray at work

>
>

[Hebar Tiltwobler]

"Bob Lehmann" <none> wrote in message
news:eFFaW0lmDHA.1072@TK2MSFTNGP09.phx.gbl...

> Less than is correct. Did you hear "then" or see "then"? Maybe you ran

into

> a regional accent.
>
> Gotta go now, the cah's erl needs to be changed.
>
> Bob Lehmann
>
> "Hebar Tiltwobler" <ready@justfooledyou-notemail.com> wrote in message
> news:uo9dTrlmDHA.2964@tk2msftngp13.phx.gbl...

> >
> > "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
> > news:%23hb2malmDHA.3612@TK2MSFTNGP11.phx.gbl...

> > >
> > > "Hebar Tiltwobler" <ready@justfooledyou-notemail.com> wrote in message
> > > news:%23juETYlmDHA.2140@TK2MSFTNGP09.phx.gbl...
> > >
> > > >
> > > > PS- I've always wondered why it less thEn instead of less thAn ..?

> > Doesn't

> > > > thAn make more sense?
> > >
> > > Where are you seeing less thEn? I can see myself saying that in
> > > conversation. "We can each take 50%. If you want less, then give me

> > more."

> > >
> > > Ray at work
> > >
> > >

> >
> > Whoops.. was thinking of VBscript.. > then..
> >
> > I'm wondering why it is not less than instead of then. Isn't "than"
> > comparitive and "then" a reference to time?
> >
> >
> >

>
>

I was thinking (not really) of "less than" or "greater than" (<>) and
"then"... what I'm really trynig to say is that I woke up too early this
morning.

[Hebar Tiltwobler]

"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:%23wZLj2lmDHA.2436@TK2MSFTNGP09.phx.gbl...

>
> "Hebar Tiltwobler" <ready@justfooledyou-notemail.com> wrote in message
> news:uo9dTrlmDHA.2964@tk2msftngp13.phx.gbl...

> >

> > > Where are you seeing less thEn? I can see myself saying that in
> > > conversation. "We can each take 50%. If you want less, then give me

> > more."

> > >
> > > Ray at work
> > >
> > >

> >
> > Whoops.. was thinking of VBscript.. > then..
> >
> > I'm wondering why it is not less than instead of then. Isn't "than"
> > comparitive and "then" a reference to time?
> >

>
> [url]www.dictionary.com[/url]
> just kidding
>
> If 5 is greater than 4 then do this
>
> That's how VBS is, although I wouldn't be surprised if things were messed

up

> grammatically from time to time. I don't know too many programmers who

are

> expert grammarians. I try though! I don't use "a lot" or say things

like,

> "If someone has a cat, they are cool." Who's they? It's he, damn it!

And

> enough with all that "he or she" or "s/he" nonsense!
>
> Ray at work
>

> >
> >

>
>

Tomaytoe tomot-o, potatoe, now that I've invented the internet I'm going
back to bed.

[Bob Barrows]

Hebar Tiltwobler wrote:

>> I suspect your database is SQL Server (why are you making
>> us guess? :-) ),

>

Oops. Sorry about that.

Bob


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"