Welcome guest, is this your first visit? Create Account now to join.
  • Login:

Welcome to the OldVersion.com Forums.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Results 1 to 2 of 2
  1. #1

    Default Help with Crystal Report v 4.0


    I am trying to update an old version of Crystal Reports.

    I need to set up a query that will give me a report of all
    records where Status = Active and DateStarted >= sStartDateEntered
    and DateStarted <= sEndDateEntered.

    I have it started, but can't figured how to add the date range.
    Can someone help me with this?

    sSQL = "{" + TABLE_CLIENTS + "." + C_FIELD_STATUS + "}"
    sSQL = sSQL + " = " + Chr(34) + STATUS_ACTIVE + Chr(34)

    This is what I tried by hard-coding it and I got an error in formula:

    {Client.Status} = "ACTIVE" AND {Clients.DateStarted} >= "01/01/2009" AND {Clients.DateStarted} <= "02/15/2009"
    Last edited by kathymc; 11-16-2009 at 05:15 PM. Reason: update query

  2. #2
    Join Date
    Dec 2006


    Well I don't know this software at all, but are you sure the date format is correct according to what it would expect ?


Similar Threads

  1. Minority Report Computing
    By Windows 98SE in forum General Discussion
    Replies: 0
    Last Post: 01-23-2007, 07:21 PM
  2. Crystal Reports 4
    By thisnameinuse in forum Requests
    Replies: 0
    Last Post: 02-27-2006, 01:19 PM
  3. Crystal Reports
    By Enrique in forum Requests
    Replies: 3
    Last Post: 04-29-2005, 03:46 PM
  4. Crystal Decisions Activex Viewer
    By bigflavor in forum Requests
    Replies: 1
    Last Post: 12-22-2004, 12:46 PM
  5. Crystal Player
    By betaluva in forum Requests
    Replies: 3
    Last Post: 08-13-2004, 08:53 AM

Posting Permissions

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