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 gkittelson 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. Planchardo

    SQL expressions not working in CR 8.5 and freezing in 11

    Thanks very much for the reply, but I eventually figured out a way to get what I wanted done without using an SQL expression at all. But thanks as well for the tip on using the SQL command option, didn't know about that.
  2. Planchardo

    SQL expressions not working in CR 8.5 and freezing in 11

    I have been trying to write an SQL query in a report in CR 8.5 and 11, but having problems in both. Here is the query: (select employee.memberid from employee where DateDiff("m",EMPLOYEE.dateOfBirth,{fn CURDATE()}) > 462 and DateDiff("m",EMPLOYEE.dateOfBirth,{fn CURDATE()}) <= 522 and...

Part and Inventory Search

Back
Top