New call-to-action
Results 1 to 3 of 3

Thread: Selecting records for a report

  1. #1
    Stephen Tierney
    Guest

    Default Selecting records for a report

    Hi, I am trying to select records from a table that occur on a specific month and year. I construct the start and end date using the ctod function sdate=ctod(month+"/"01"/"+yearc) and edate=ctod(month+"/"day"/"yearc). The variables all return the correct numbers as required in character format. The filter expression for the report set in the report is set as between(Date_shipped,Var-"sdate,Var-"edate). However the report is not filtered for some reason. Any ideas?

    Regards

    Steve

  2. #2
    VAR davej's Avatar
    Real Name
    Dave Jampole
    Join Date
    Apr 2000
    Location
    Haughton, LA ( just east of Shreveport, Louisiana)
    Posts
    2,524

    Default RE: Selecting records for a report

    Stephen,

    The Between function works on character strings. You should to use the Between_date function.

    Dave

  3. #3
    "Certified" Alphaholic Keith Hubert's Avatar
    Real Name
    Keith Hubert
    Join Date
    Jul 2000
    Location
    London, UK
    Posts
    6,930

    Default RE: Selecting records for a report

    Stephen,

    The way I did this was to build an action script that ran off a button.

    The first part was to get the Start_date and End_date using a dialog box. With the variable values populated the next part of the script called for the report but using the variables in the Between() function in the filter. The Action Script did all the work for me, so you do not have worry about converting the date to character and back again.

    If you post that bit of your app here I can show you how I did it.

    RegardsKeith HubertAlpha Guild MemberLondon.KHDB Management Systems

Similar Threads

  1. selecting records in a report
    By Al Kadin in forum Alpha Five Version 5
    Replies: 2
    Last Post: 08-23-2004, 11:23 AM
  2. selecting records
    By Ernest Paushter in forum Alpha Five Version 5
    Replies: 1
    Last Post: 02-13-2003, 06:55 AM
  3. selecting records in report
    By Frank Ryan in forum Alpha Five Version 5
    Replies: 1
    Last Post: 10-22-2002, 07:49 AM
  4. Selecting records for report header
    By Larry Ternowski in forum Alpha Five Version 4
    Replies: 1
    Last Post: 10-09-2002, 04:18 PM
  5. Selecting records for Print
    By Rick Hamilton in forum Alpha Five Version 4
    Replies: 3
    Last Post: 06-23-2002, 09:55 AM

Bookmarks

Posting Permissions

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