Results 1 to 3 of 3

Thread: Crystal Reports 10.2 Is the Between Operator valid?

  1. May 24th, 2007, 05:26 PM #1
    blakemckenna
    blakemckenna is offline

    Thread Starter
    PowerPoster
    Join Date
    Jan 2004
    Location
    Southern California
    Posts
    5,034

    Crystal Reports 10.2 Is the Between Operator valid?

    Is this a valid statement for Crystal Reports 10.2???

    Code:
    ({tblTimeSheetDetail.monDate} BETWEEN '5/7/2007' AND '5/20/2007' AND {tblTimeSheetDetail.sunDate} = '5/20/2007') AND {tblTimeSheetDetail.project} > ''
    Blake
    Reply With Quote Reply With Quote
  2. May 24th, 2007, 05:34 PM #2
    brucevde
    brucevde is offline
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: Crystal Reports 10.2 Is the Between Operator valid?

    No.

    Crystal has several Range functions. The syntax of a range that includes the end points is

    {FieldName} In X To Y
    Reply With Quote Reply With Quote
  3. May 24th, 2007, 05:42 PM #3
    blakemckenna
    blakemckenna is offline

    Thread Starter
    PowerPoster
    Join Date
    Jan 2004
    Location
    Southern California
    Posts
    5,034

    Re: Crystal Reports 10.2 Is the Between Operator valid?

    So would this be correct?

    Code:
    ({tblTimeSheetDetail.monDate} IN '5/7/2007' TO '5/20/2007' AND {tblTimeSheetDetail.sunDate
    Blake
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width