0

I have a date field named "TermDate'. I would like an expression in Query Builder to only show features where termination date is in the future. My date field displays as '2017-09-27 09:59:01' I'm using Enterprise Geodatabase with SQL server. I thought I could just use the NOW() function but I'm having no luck. I am using arcGIS 10.2.

I have a polygon feature class that is symbolized with shading for parcels that have a recovery agreement. After a certain period of time, the recovery agreements expire and I would like those to no longer be visible, so that only those with termination dates in the future appear on the map.

1

getdate() is the way to get Now under query builder

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.