Index: trunk/ippTools/share/pztool_find_completed_exp.sql
===================================================================
--- trunk/ippTools/share/pztool_find_completed_exp.sql	(revision 23618)
+++ trunk/ippTools/share/pztool_find_completed_exp.sql	(revision 23643)
@@ -3,4 +3,5 @@
     camera,
     telescope,
+    dateobs,
     state
 FROM (
@@ -8,5 +9,6 @@
         pzDownloadImfile.*,
         pzDownloadExp.state,
-        summitExp.imfiles
+        summitExp.imfiles,
+        summitExp.dateobs
     FROM pzDownloadExp
     JOIN summitExp