Date equals today ArcGIS Pro

549
3
Jump to solution
01-26-2023 02:17 PM
MeleKoneya
Occasional Contributor III

I am trying to get all the Fire Incidents that occurred today.

dispatch_date = CURRENT_DATE()

Does not work in ArcGIS Pro.    What am I doing wrong here?

Thank you,

Mele

0 Kudos
1 Solution

Accepted Solutions
MeleKoneya
Occasional Contributor III

In SQL this works dispatch_date >= CONVERT(date, GETDATE())

View solution in original post

3 Replies
SLouq
by MVP Regular Contributor
MVP Regular Contributor

dispatch_date is on or after CURRENT_DATE()

0 Kudos
MeleKoneya
Occasional Contributor III

Thank you.   Does that go in SQL view?    That didn't work there. Nor here

MeleKoneya_0-1674772210896.png

 

0 Kudos
MeleKoneya
Occasional Contributor III

In SQL this works dispatch_date >= CONVERT(date, GETDATE())