Date calculation

From: Bob (bhorwitz_at_zachys.com)
Date: 08/03/04

  • Next message: Hugo Kornelis: "Re: Date calculation" 
    Date: Tue, 3 Aug 2004 10:37:13 -0700

    Im relatively new with sql and im having a problem
    creating a criteria based on todays date less 150 days.

    I tried to use the following...
       < GetDate () -150 however it will not let me use this.

    I know that there must be away to do this, but I need
    help.. Thank you in advance

  • Next message: Hugo Kornelis: "Re: Date calculation"

    Relevant Pages

    • Re: Date calculation
      ... >creating a criteria based on todays date less 150 days. ... Also remember that getdate() gives current date *AND* time. ... you'll have to use some extra tricks to get rid of the time portion. ...
      (microsoft.public.sqlserver.mseq)
    • Re: SQL queries that have parameters passed by user
      ... Erland Sommarskog wrote: ... >> several fields and filters on a criteria that I would like to be user ... >> The query works fine in MS SQL and seems to be fairly quick, ...
      (comp.databases.ms-sqlserver)
    • Re: SQL Syntax Error
      ... match all the criteria you input. ... SQL view and never open it in the query grid view. ... The syntax for the "where" statement is incorrect becuase of this. ...
      (microsoft.public.access.queries)
    • Re: QueryTables - Retrieving Data
      ... data in Excel then filter it using cell formulas, pass your criteria ... ('sql datasource' is particularly vague; if you mean SQL Server then ... The column has an eight digit account code that I need to ... When I 'double click' a cell in the accountnumber ...
      (microsoft.public.excel.misc)
    • Re: time criteria in query
      ... Prove me wrong by providing the SQL ... Or...start a query with just the date field ... criteria, it does actually return the time value properly. ... SQL Server with ODBC, Access should use DAO and therefore require the ...
      (microsoft.public.access.queries)