Rob and Tony- Thanks muchly!
Moshe
-----Original Message-----
From: ASP-Support-Group%40yahoogroups.com">ASP-Support-Group
yahoogroups.com
[mailto: ASP-Support-Group%40yahoogroups.com">ASP-Support-Groupyahoogroups.com] On Behalf Of Atkinson, Robert
Sent: Tuesday, February 06, 2007 5:53 PM
To: ASP-Support-Group%40yahoogroups.com">ASP-Support-Groupyahoogroups.com
Subject: RE: -=(ASP-Support-Group)=- between 2 dates
You should be able to do 
br>
If cdate(shipdate) > cdate("2/25/2007") AND cdate(shipdate) <
cdate("03/06/2007") then....
(http://groups.google.com/group/microsoft.public.inetserver.asp.general/brow
s
e_frm/thread/65da5a1a4ffb1f0/426e8d9ebefe6ea4?lnk=gst&q=compare+dates&rnum=2
#
426e8d9ebefe6ea4)
Rob.
-----Original Message-----
From: ASP-Support-Group%40yahoogroups.com">ASP-Support-Groupyahoogroups.com
[mailto: ASP-Support-Group%40yahoogroups.com">ASP-Support-Groupyahoogroups.com] On Behalf Of Atkinson, Robert
Sent: 06 February 2007 15:46
To: ASP-Support-Group%40yahoogroups.com">ASP-Support-Groupyahoogroups.com
Subject: RE: -=(ASP-Support-Group)=- between 2 dates
You can't compare dates like this, because ASP is comparing the ASCII values
of each character.
You should convert all dates into a 'YYYYMMDD' format and then do the
comparison, or compare all dates in their raw binary format.
Rob.
-----Original Message-----
From: ASP-Support-Group%40yahoogroups.com">ASP-Support-Groupyahoogroups.com
[mailto: ASP-Support-Group%40yahoogroups.com">ASP-Support-Groupyahoogroups.com] On Behalf Of Moshe Tapnack
Sent: 06 February 2007 15:37
To: ASP-Support-Group%40yahoogroups.com">ASP-Support-Groupyahoogroups.com
Subject: -=(ASP-Support-Group)=- between 2 dates
Hey folks.
I am trying to check that a certain date is between 2 dates and it aint
going
:(
I am using this:
If cdate(shipdate) > "2/25/2007" AND cdate(shipdate) < "03/06/2007"; then....
Where the shipdate comes through as 2/26/2007 or 02/26/2007
What am I doing wrong ??
Thanks!
Moshe
****************************************************************************
*******
Any opinions expressed in email are those of the individual and not
necessarily those of the company. This email and any files transmitted with
it are confidential and solely for the use of the intended recipient
or entity to who they are addressed. It may contain material protected by
attorney-client privilege. If you are not the intended recipient, or a
person responsible for delivering to the intended recipient, be advised that
you have received this email in error and that any use is strictly
prohibited.
Random House Group + 44 (0) 20 7840 8400
http://www.randomhouse.co.uk
http://www.booksattransworld.co.uk
http://www.kidsatrandomhouse.co.uk
Generic email address - enquiries%40randomhouse.co.uk">enquiriesrandomhouse.co.uk
Name & Registered Office:
THE RANDOM HOUSE GROUP LIMITED
20 VAUXHALL BRIDGE ROAD
LONDON
SW1V 2SA
Random House Group Ltd is registered in the United Kingdom with company No.
00954009, VAT number 102838980
****************************************************************************
*******
Group homepage is here:
http://groups.yahoo.com/group/ASP-Support-Group
To unsubscribe from this group, send an email to:
ASP-Support-Group-unsubscribe%40yahoogroups.com">ASP-Support-Group-unsubscribeyahoogroups.com and cross your fingers
because Yahoo is 5h1te.
Yahoo! Groups Links
.
