yogi_Count Number Of Machines Older Than Specified Number Of Years

                                          Google Spreadsheet   Post  #1385
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct 07, 2013
user: Chad S. (http://productforums.google.com/forum/?zx=6ycrwucpw4f9#!category-topic/docs/spreadsheets/3YaeC-rDR54)
'Google Spreadsheet, Query Date older than 5 years ago

I am trying to query a count of machines that are older than 5 years.

My machine data is in one tab with date time stamps in column K like "8/8/2008 8:08:08"

I have tried many different variations to get the query right... but my latest is like this

=query(RawDataMachines!B:K,"select count(K) WHERE K + INTERVAL 5 YEAR < NOW() label count(A1''")

Been trying to solve this issue for over a week now.

Any help would be appreciated.

Thanks in advance.

--------------------------------------------------------------------------------------------------------------------------------------------------