Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    Is
    Posts
    21

    Unanswered: Filter With Dates Problem

    I have 3 Fields : [date], [FromDate] and [UntillDate] i made a filter to show me the [date] whice are between [FromDate] and [UntillDate]

    DoCmd.ApplyFilter , "[date] > [FromDate] and [date] <[UntillDate] "

    but when im runing the prog Access tells me to insert Data to [FromDate] and [UntillDate] but i already insert a data to those fields ???
    Oren Zzz

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Lightbulb Re: Filter With Dates Problem

    Originally posted by orenz
    I have 3 Fields : [date], [FromDate] and [UntillDate] i made a filter to show me the [date] whice are between [FromDate] and [UntillDate]

    DoCmd.ApplyFilter , "[date] > [FromDate] and [date] <[UntillDate] "

    but when im runing the prog Access tells me to insert Data to [FromDate] and [UntillDate] but i already insert a data to those fields ???
    What format does your date have? You should change your format to the mm/dd/yy and dont forget to use the # # so that your date looks like #011/27/03# [Today]

Posting Permissions

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