chuckshaw

Selecting records from table's date field and deletiing expired dates.

Discussion created by chuckshaw on Sep 18, 2013
Latest reply on Sep 18, 2013 by Caleb1987
I have zero programming skills here, so I need some help.  I have a SDE Feature Class (SQL) showing where current Public Works Department's Projects are currently taking place though out the city.  When a project location is added, someone populates the "begdate" field (Project Start Date) and the "enddate" field (Project Completion Date) for that project record.  I want to write a script/program that will query the "enddate" field looking for records where the dates have expired. If it's older than today's date on my computer, then those records are selected and deleted from this Feature Class.  Where do I start?  Any suggestions would be appreciated.

Thanks,
Chuck

Outcomes