Results 1 to 2 of 2

Thread: datacriteria

  1. #1
    Join Date
    Aug 2003

    Unanswered: datacriteria

    Problem with a datacritera in a selection query.

    I have a list of persons, with their birth dates. I want to see all persons born in the second quarter of the year.

    The expression for that is : DatePart("k"; [BirthDate])=2

    Automatically I get a slash before the k
    and I get a dialog box mentioning an error

    what did I do wrong?

  2. #2
    Join Date
    Jul 2003

    Re: datacriteria

    Format for this command is:

    (DatePart("q", [BirthDate]) = 2) and (DatePart("yyyy", [BirthDate]) = 2003)

Posting Permissions

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