SQL Query to Select All Dates Starting Today and Two Years Prior

08-14-2019 08:26 AM
by Anonymous User
Not applicable

Hello! I am trying to create an SQL query through the Select By Attribute window on a date field that will select the current date and everything two years prior. I can't seem to find anything online where this has been completed successfully. I am using ArcMap 10.7 and trying to do the Select By Attribute on a Date field which I manually enter the dates into. The reason I want an SQL expression that will grab the Current Date and everything prior for two years is because this expression will then be incorporated into a nightly run model so the date is consecutively changing as time goes on.

One thing that I think is important to mention is that I am not entering new dates into my database daily. With this being said then, can I use CURRENT_DATE  in my expression?

For example: I wrote this post on 08/14/2019. So the expression I am looking for, when run today would select all dates between 08/14/2019 and 08/14/2017 and then tomorrow the expression would select all dates between 08/15/2019 and 08/15/2017.

Also my selection field is called: LegalEnd_Da

I have tried the following expression, which verifies successfully yet nothing in my attribute table is actually selected:

"LegalEndDa" <= (CURRENT_DATE -750) AND "LegalEndDa" >= CURRENT_DATE

Thank you in advance and I hope I have clarified my end goal clearly enough. 


0 Kudos
1 Reply
by Anonymous User
Not applicable

After writing this post and staring at my expression for sometime, I realized I had my Less Than/Greater Than symbols backwards. The expression worked like a charm, in case anyone is out there trying to do the same thing!