Select By Attributes SQL expression CURRENT_DATE

Jim — Fri, 07 Apr 2023 16:47:15 GMT

Hello ArcPro Brains,

I am trying to set up a model builder to Select By Attribute all the records that were started the day before. I am using the SQL window to add the code below

start_time <= (CURRENT_TIMESTAMP - 1)

Unfortunately, I am returning zero records and am not sure why. If I simply write:

start_time <= CURRENT_TIMESTAMP

I return all the records before the present. However, I every time I include the addition or subtraction I return the following "The SQL expression is valid, but no records were returned".

I've also tried CURRENT_DATE in the same formula with the same results. Thanks!

Re: Select By Attributes SQL expression CURRENT_DATE

RhettZufelt — Fri, 07 Apr 2023 17:31:19 GMT

Might try the DATEADD function.

start_time > DATEADD(day,-1,CURRENT_TIMESTAMP)

topic Re: Select By Attributes SQL expression CURRENT_DATE in ArcGIS Pro Questions

Select By Attributes SQL expression CURRENT_DATE

Re: Select By Attributes SQL expression CURRENT_DATE