I have GP Service that executes a select by attribute using a date range criteria. The feature class it references is appended with new records weekly. The GP services will not retrieve the appended records when it is executed. It does not return an error on execution it simply returns 0 records. It will still only retrieve records from the date ranges available when the table was initially populated.
The model that was used to develop the GP Service will retrieve the records when run from ArcMap. The feature class displays all the records in ArcMap and select by attribute for the appended records will work. The records can also be queried fro SQL Server directly.
Any guidance or help on what may be causing this would be appreciated.