Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Barbera

    #DateDiff("D",date, NOW())# <= #Form.Days#

    Thanks Jackied, it worked! I declared <cfset MinDate = #DateAdd(&quot;d&quot;, -Form.Days, Now())#> before the query and in the query I used AND MessageDate >= #MinDate#. This was what I wanted so thanks for the solution.
  2. Barbera

    #DateDiff(&quot;D&quot;,date, NOW())# &lt;= #Form.Days#

    Thanks for your replies. Date is not the variable I used but I used in in this exemple to make the problem clear and simple. I will try the CFSET declaration before the query. Otherwise I will have to use a statement which the MySQL database will understand.
  3. Barbera

    #DateDiff(&quot;D&quot;,date, NOW())# &lt;= #Form.Days#

    Thanks but no, that's not possible. The variable is declared in the query so I can't use a cfset statement.
  4. Barbera

    #DateDiff(&quot;D&quot;,date, NOW())# &lt;= #Form.Days#

    Hello, I have a problem with using DateDiff in a query. #DateDiff(&quot;D&quot;,date, NOW())# <= #Form.Days# The error is that he cannot determine the value of 'datum' but that's very very correct. Outside the query it's no problem to use the same DateDiff statement. It seems I cannot already...

Part and Inventory Search

Back
Top