Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2012

    Exclamation Unanswered: calculate years to particular date

    iam entering date , and number of year from form i want query to calculate who have more than number of years entered in textbox in the form
    query is
    SELECT Table1.ID, Table1.Dof, ([Forms]![Form1]![Text0]-[Dof])/365.25 AS Expr1
    FROM Table1
    WHERE (((([Forms]![Form1]![Text0]-[Dof])/365.25)>[Forms]![Form1]![Text2]));
    if any can help please
    Attached Files Attached Files

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 15
    To extract the year from an expression that represents a valid date, simply use the Year() function:
    Have a nice day!

Posting Permissions

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