Results 1 to 3 of 3

Thread: problem selectionformula

  1. Nov 13th, 2003, 12:08 AM #1
    hublisunil
    hublisunil is offline

    Thread Starter
    New Member
    Join Date
    Nov 2003
    Posts
    4

    Question problem selectionformula

    Hi,

    I am doing a project in VB and MS Access. I have designed one crystal report which fethc data from one table. Now I want to select the records only between some dates (this date is one field in the table). In the VB code i wrote code like this

    cryst.selectionformula = "{tablename.date} >= '1/1/2003' and {tablename.date} <= '10/10/20003' "

    but it is not coming, giving error message like "Error in formula".
    Is my selectionformula is correct or not, can we compare dates by enclosing between single quotes('). Please any one can help me.

    Thanks in advance.

    sunil.
    Reply With Quote Reply With Quote
  2. Nov 13th, 2003, 02:30 AM #2
    brucevde
    brucevde is offline
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758
    '10/10/20003' - Is this a typo in your post or your actual code? The Year 20003 would cause problems.
    Reply With Quote Reply With Quote
  3. Nov 13th, 2003, 03:22 AM #3
    hublisunil
    hublisunil is offline

    Thread Starter
    New Member
    Join Date
    Nov 2003
    Posts
    4
    Sorry,

    It is typing mistake.
    actually it is '10/10/2003'
    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