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   Oct 07, 2013
user: Chad S. (!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.