recordselection formula woes

From: Gary P (qssoftLESSSPAM_at_mchsi.com)
Date: 08/05/04 

Date: Thu, 05 Aug 2004 15:10:03 GMT

I'm using Crystal for vb/net2003 and I've got an Access db table named
tblLact with 3 records - the values for the fields in question are

fldID=129 fldBeginDate= 3/17/2004
fldID=27 fldBeginDate= 3/15/2004
fldID=129 fldBegindate= 4/23/2004

When I do a report on the table with no RecordSelection formula, I get all 3
However when I set the rptdoc.datadefinition.recordselectionformula=

{tblLact.fldBeginDate} IN (Date (1980,01,01) TO Date (2004,08,05)) AND
{tblLact.fldID}=129

I will receive only the first record (3/17/04) and not the third
If I change the 129 to 27 I will receive nothing, though expecting the
second record
If I drop the date part of the string and just have {tblLact.fldID}=129 (or
27) it works as expected.
If I drop the ID part of the string and leave the {tblLact.fldBeginDate} IN
(Date (1980,01,01) TO Date (2004,08,05)) I would expect to get all 3
records but once again only get the first.

What am I missing here? There seems to be something wrong with my IN Date to
Date but I don't see it. Is there some reason I seem to only get the first
matching record? Actually that's not even true when the ID is 27, rec#2
would be the first match, but I get nothing

Any clues? Thanks
Gary

Relevant Pages

  • RE: Date calculations and daylight saving
    ... If you're expecting it to be ... >> string to seconds and then localtime and strftime to ... We get penalised if we pass this target completion time so the script ... > the local time to GMT, which is a function of the time zone. ...
    (perl.beginners)
  • Re: Static typing aint so bad, after all...
    ... The problem is that dynamic typing, while very powerful, also hid the ... type the method was expecting. ... the answer to this is simply better documentation. ... that it's a (string or an object that should be able to ducktyped to a ...
    (comp.lang.ruby)
  • Re: Protecting MySQL Injection from PHP form
    ... you should be checking against type (expecting a number? ... If someone is posting a string of 8000 ... if all you do is check to see if it's empty implements isset, ... What you need to do is check for SQL injections, ...
    (php.general)
  • Re: Populating the data of two Textboxes into One textbox
    ... how does it differ from what you're expecting? ... > Public Function CalculateFindingNo(Val1 As String, ... > I am calling in the AfterUpdateEvent of txtbox2 ... > Its not working folks ...
    (microsoft.public.access.forms)