(imported comment written by Kenz91)
Thanks Noah. I’ve gotten closer to what I want but getting a new error. Here is what I have.
Q: (values “displayname” of it, (if (exists value “InstallDate” of it AND exists value “InstallDate” of it as string) then (value “InstallDate” of it as string) else (“No Install Date”)), ((((current date - date (last 2 of it & " " & (month (last 2 of first 6 of it as integer) as three letters) & " " & first 4 of it)) of first 8 of (values “InstallDate” of it as string))) as string | “Bad or missing install date”)) of keys whose (exists value “UninstallString” of it AND ((not exists value “SystemComponent” of it) OR (exists value “SystemComponent” of it AND name of it starts with “{” AND name of it contains “}” AND (exists match (regex “(9|A|B|C)(0|1)1(2|4)\d\d\d\d-(0011|0012|0013|0014|0017|002E|002F|0030|0031|0033|0035|003A|003B|0044|0051|0052|0053|0057|00BA |00CA|10D7|110D)-(0000|0409)-(0|1)000-(0|1)000000FF1CE$”) of preceding text of first “}” of following text of first “{” of name of it))) AND (if (exists value “DisplayName” of it AND exists value “DisplayName” of it as string) then ((it does not contain “Hotfix” AND it does not contain “Security Update for” AND it does not contain “Update for” AND it does not contain “Security Update for Windows” AND it does not contain “Update for Windows” AND it does not contain “Security Update for Microsoft” AND (length of it > 0) AND (number of substrings " " of it < length of it)) of (value “DisplayName” of it as string)) else true)) of keys “HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall” of (if x64 of operating system then (x32 registry; x64 registry) else registry)
A: Administration Tools Pack, 20081229, 1022 days
A: Rainbow iKey Driver v3.4.5.108, No Install Date, Bad or missing install date
A: Apple Application Support, 20110930, 17 days
A: Lotus Notes Client 8.5.1, 20091119, 697 days
A: Microsoft Visual C++ 2005 Redistributable, 20110629, 110 days
A: MSXML 4.0 SP2 Parser and SDK, 20081217, 1034 days
A: WIMGAPI, 20110516, 154 days
A: SafeNet Borderless Security PK Client, 20090805, 803 days
A: PacketTrap pt360 Tool Suite, 20090210, 979 days
A: DEP-IE-Enabled, No Install Date, Bad or missing install date
A: SMART Install Manager, 20090129, 991 days
A: MSXML 4.0 SP2 (KB954430), 20081217, 1034 days
A: Microsoft SQL Server Management Objects Collection , 20090728, 811 days
A: PowerPointFRClassButtons Version 1.1, 20110405, 195 days
A: SQLXML4, 20081217, 1034 days
A: SecureDoc Disk Encryption, 20090306, 955 days
A: Microsoft Office Professional Plus 2007, 20111007, 10 days
A: Microsoft Office 2007 Service Pack 2 (SP2), No Install Date, Bad or missing install date
E: Could not convert value to required type.