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.

PolyGeo ♦
65.5k29 gold badges115 silver badges350 bronze badges
asked Sep 27, 2017 at 17:11
1

1 Answer 1

1

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

answered Sep 27, 2017 at 18:31
1
  • Happy to helped you , don't forget to mark the answer as resolve Commented Sep 28, 2017 at 7:03

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.