Monday, October 7, 2013

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