I have a hosted feature layer in AGOL that I want to query from ArcMap (10.2.2) to find records where a date field occurs before another date field plus one year. When the data resides in a file geodatabase I can do this query using the following syntax:
Date_Cert_Due < Date_Work_Finished+365
This selects those records whose Date_Cert_Due is before the Date_Work_Finished plus one year. When I try to do the same query on my hosted feature layer the query looks very similar:
"Date_Cert_Due" < "Date_Work_Finished" + 365
When I verify the SQL, I get "There was an error with the expression."
I have tried using single quotes and no quotes and they didn't work. What am I missing? Can I do this type of query of a hosted feature layer from ArcMap on my desktop?
Thanks!