Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

future date value

Discussion in 'Information Technology' started by Dendalee, Jul 28, 2006.

Tags:
  1. Dendalee

    Dendalee
    Expand Collapse
    Guest

    I am trying to filter dates based on the DateAdd field in my query. It will
    not allow me to use specific criteria in the query under the DateAdd field. I
    can filter if I use enter the date in the expression such as Between
    #04/01/2005# And #05/01/2007# in the DateAdd field. I want to filter the
    criteria based on the dates I enter in a form. I am using this as my
    expression.

    Between [Forms]![Employee Information]![Start Date] And [Forms]![Employee
    Information]![End Date]

    This expression works fine in all fields execpt the dateadd field
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Amit Jani: Trump Leverages Fear In Americans, Wrong Candidate For Our Nation's Future Breaking News Feb 18, 2016
    World Afghanistan's Sikhs face an uncertain future Breaking News Feb 28, 2014
    Sikh Foundation Reflections on the Future of Punjab's Economy Sikh Organisations Oct 24, 2013
    USA A Map of America's Future - 9 Economies, Cultures and Population Trends? Breaking News Sep 10, 2013
    SciTech Future of Organs? Synthetic Tissue Built with 3-D Printer Breaking News Apr 6, 2013

  3. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    Do you have a Field called DateAdd, or you mean that you are using the
    DateAdd function?

    If it's a field name, I recomand changing it, because it's a build in
    function name in Access.
    If the you ,ean using the function, can you post the full SQL?
    But before that, check if the DateAdd actually return values without the
    criteria


    --
    Good Luck
    BS"D


    "Dendalee" wrote:

    > I am trying to filter dates based on the DateAdd field in my query. It will
    > not allow me to use specific criteria in the query under the DateAdd field. I
    > can filter if I use enter the date in the expression such as Between
    > #04/01/2005# And #05/01/2007# in the DateAdd field. I want to filter the
    > criteria based on the dates I enter in a form. I am using this as my
    > expression.
    >
    > Between [Forms]![Employee Information]![Start Date] And [Forms]![Employee
    > Information]![End Date]
    >
    > This expression works fine in all fields execpt the dateadd field
    >
     
  4. Dendalee

    Dendalee
    Expand Collapse
    Guest

    Actually I got it figured out I had to use a CDate() expression so that it
    would recognize the information as a date rather than just data. Thanks.

    D

    "Ofer Cohen" wrote:

    > Do you have a Field called DateAdd, or you mean that you are using the
    > DateAdd function?
    >
    > If it's a field name, I recomand changing it, because it's a build in
    > function name in Access.
    > If the you ,ean using the function, can you post the full SQL?
    > But before that, check if the DateAdd actually return values without the
    > criteria
    >
    >
    > --
    > Good Luck
    > BS"D
    >
    >
    > "Dendalee" wrote:
    >
    > > I am trying to filter dates based on the DateAdd field in my query. It will
    > > not allow me to use specific criteria in the query under the DateAdd field. I
    > > can filter if I use enter the date in the expression such as Between
    > > #04/01/2005# And #05/01/2007# in the DateAdd field. I want to filter the
    > > criteria based on the dates I enter in a form. I am using this as my
    > > expression.
    > >
    > > Between [Forms]![Employee Information]![Start Date] And [Forms]![Employee
    > > Information]![End Date]
    > >
    > > This expression works fine in all fields execpt the dateadd field
    > >
     

Share This Page